Hello , I want to Join PODetail and ShipDtl using the key ordernum and company , But when i joined the table the query result doesn’t return any rows . but when i copy the same query and run in SqlServer Management the value is displaying , can any one please help me over here.
@Murali The PODtl OrderNum is not the same field as in the ShipDtl (at least when it’s restricted by Company). What are you trying to return?
i think you may want the purchase order line/release BTOOrdernum and line and release - these connect to the Sales order
1 Like
@Matthew_Morgan I Want to return Shipdate from ShipHead Table for a PO, is there anything i can do about .I can Fetch result using same query using SQL Server Managament studio .
BAQ preview contains disclaimer 
but it looks like no one reads it 
The query that BAQ executes is not the query in the preview.
The preview shows the simplified version without a lot of additional security-related stuff.
2 Likes
@Murali Just so I’m not misunderstanding, you want to pull data for shipments of customers’ sales orders, not purchases your company is making from vendors, correct?