example of exist join in MSD axapta


 select student exists join samcustomer where student.id == samcustomer.id  
 {  
 a=student.id;  
 b=student.name;  
 c=samcustomer.id;  
 d=samcustomer.email;  
 print " id = " +int2str(a);  
 print " name = " +(b);  
 print " id = " +int2str(c);  
 print " email = " +(d);  
 }