Using Join and Inner Join in D365 F&O: X++ Code Examples and Best Practices

Rumman Ansari   Software Engineer   2024-09-22 03:48:21   742  Share
Subject Syllabus DetailsSubject Details
☰ TContent
☰Fullscreen

Table of Content:

Join or Inner Join in D365 F and O - X++ Code

Join or Inner Join in D365 F&O - X++ Code Join or Inner Join in D365 F&O - X++ Code Join or Inner Join in D365 F&O - X++ 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 join cust
           where orders.CustomerID == cust.CustomerID
       {
           Info(strFmt("%1 %2, %3", cust.CustomerID, cust.CustomerName, orders.OrderID ));
       }
   }
 
}
Join or Inner Join in D365 F&O - X++ Code