I'm exploring SAP B1 Service Layer and currently working on adding SQL query to Service Layer. Specifically, I'm interested in performing a left join on sql select query. Has anyone successfully implemented a left join in a SQL select query when interacting with SAP B1 Service Layer? Consider below as example.
Orders LEFT OUTER JOIN
(SELECT OrderID,ProductID, Quantity
FROM OrderDetails) AS OrderDetails ON
Orders.OrderID = OrderDetails.OrderID;