Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP B1 Service Layer: Left join on SQL select query

jdpatel
Member
0 Kudos

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;
  • SAP Managed Tags:
0 REPLIES 0