Skip to Content
0
Former Member
Jan 19, 2011 at 02:05 PM

Query to Buyers' Orders including batch data.

53 Views

Hi!

I would need to have an SQL query that will compile a list of all the items in the Buyersu2019 Orders including batch data. I have the part of the query that compiles the list of items buti t gives no info on what the batch data of the single items. Does any of you have any idea which of the tables must be added to the query and what key column does this one use to connect to the opther two tabsles.

SELECT * FROM ORDR t1
left join RDR1 t2 on t1.DocEntry = t2.DocEntry
where t1.DocStatus ='O' and t1.CANCELED ='N'