query from 2 screens
How do we get data from 2 screens like Goods receipt and landed cost in a single query.
Gordon Du replied
You can try something like:
Select * From PDN1 T0 Left Join IPF1 T1 ON T1.BaseEntry = T0.DocEntry
You can choose any fields you like from two tables for the query.
If you need header table as well, it can be done through Inner Join for OPDN and Left Join for OIPF.