In my database I save all the consignments details in Cons table. Supplier payment goes through 3 methods; Bank, Discount and Under. Every supplier's payment does not necessarily involve all three methods. That's why I have created 3 separate tables for separate types of payments. But I need to make a consolidated query whereby I will get 3 types of payments side by side along with payment date and supplier ID. End result should look like the pic below.
There is common date ie 08/08/2020 where I have both Bank and Discount payment to same supplier. So, those two transactions should appear in the same line ans in the pic. I have created 3 queries TrBank, TrDisc and TrUnd, but don't know how to join them.
I don't have a clue how to achieve this.
Database is attached for your kind inspection. x - Copy.zip