Two tables in one report..

Question

User2021533260 posted

Hi,

     I want to display two tables in one single report as follows.

Purchase                     sales

1 abc  def                1 afds  fdsa

2 fdas fedaf             2 vdsa   fvdasfda

3 fcd   fde                3 vds    gdag

Is it possible to create like this?

Answer 1

User306743125 posted

Yes, JOIN the reports in your SELECT query and use that as the dataset for your report

Answer 2

User-929656654 posted

When you are joining, make sure you pick the column that relates the two table. It looks the first column in your two table is related. But the relationship is not direct as it goes through the master table that should be linked with both Purchase and sales. So you should bring the product table (I guest that is your master table) to relate both purchase and sales.