static void OuterJoinSelectJob3(Args _args)
{
SalesOrder recSalesOrder;
SalesOrderLine recSalesOrderLine;
struct struct4;
;
struct4 = new struct
("int SalesOrderID;"
+ "date DateAdded;"
+ "str SalesOrderLineID;"
+ "int Quantity"
);
while
SELECT
from
recSalesOrder
OUTER JOIN recSalesOrderLine
WHERE
recSalesOrder.SalesOrderID == recSalesOrderLine.SalesOrderID
&& recSalesOrderLine.Quantity == 66
{
struct4.value("SalesOrderID", recSalesOrder.SalesOrderID);
struct4.value("DateAdded", recSalesOrder.DateAdded);
struct4.value("SalesOrderLineID", recSalesOrderLine.SalesOrderLineID);
struct4.value("Quantity", recSalesOrderLine.Quantity);
info(struct4.toString());
}
}
Like this:
Like Loading...