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


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

return non matching records from left table only.

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

Orders - Table

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

Customers - Table

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

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 notexists join  cust
           where orders.CustomerID == cust.CustomerID
       {
           Info(strFmt("%1 %2, %3", cust.CustomerID, cust.CustomerName, orders.OrderID ));
       }
   }
 
}

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

Comments