SAP B1 Service Layer: Left join on SQL select query

[jdpatel]

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;