How to link two different tab in query report

Hi Guys ,

I would like to link two different table in one query report , how to do that ? I want all the production orders to appear in the Ordered items to be delivered report when I select a sales order . Kindly advise .


If you look at the query for this report, it is already joining multiple tables, you can edit it to add something else as well, but you will need some SQL query JOIN writing knowledge.