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'