SAP B1 Service Layer: Left join on SQL select query

jdpatel — Tue, 21 Nov 2023 16:20:10 GMT

Hey Community,

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.

SELECT  Orders.OrderID,   
Orders.OrderDate,    
OrderDetails.ProductID,    
OrderDetails.Quantity FROM     
Orders LEFT OUTER JOIN     
(SELECT OrderID,ProductID, Quantity     
FROM OrderDetails) AS OrderDetails ON     
Orders.OrderID = OrderDetails.OrderID;

topic SAP B1 Service Layer: Left join on SQL select query in Application Development and Automation Discussions

SAP B1 Service Layer: Left join on SQL select query