Exists Join in D365 F and O - X++ Code

 

Exists Join in D365 F and O - X++ Code

This will give output -> matching records from only left table only.

Orders - Table

Customers - Table

Write Code

 internal final class JoinExampleClass
{
   /// <summary>
   /// Class entry point. The system will call this method when a designated menu 
   /// is selected or when execution starts and this class is set as the startup class.
   /// </summary>
   /// <param name = "_args">The specified arguments.</param>
   public static void main(Args _args)
   {
       Customers cust;
       Orders orders;
 
       while select * from orders exists join  cust
           where orders.CustomerID == cust.CustomerID
       {
           Info(strFmt("%1 %2, %3", cust.CustomerID, cust.CustomerName, orders.OrderID ));
       }
   }
 
}