Hello Xperts
I want to produce a report that will show Invoices by country and their BPChCODE and BPCh NAME
In order to get the BPCh name, I have linked a second OCRD Table.
but now the query gives me only the Invoices that has BPChCODE, I want to see ALL of the Invoices, inclding ones that dont have a BPChCode.
SELECT T1.DocNum, T1.CardCode, T1.CardName, *T1.bpchcode, T4.CARDNAME,* T0.ItemCode FROM INV1 T0 INNER JOIN OINV T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OCRD T2 ON T1.CardCode = T2.CardCode INNER JOIN OCRY T3 ON T2.Country = T3.Code *INNER JOIN OCRD T4 ON T1.bpchcode = T4.CardCode* WHERE T3.Name = '[%0]'
Please Help ..... Thanks !
Medalion.