Hi. I'm working on our own accounting system which includes cash, bank account, inventory etc. I have the tables for all these processes. Now i want to get the extract of a customer(or safe, supplier, stock, bank account). For customer, the related tables are cash_from_customers, sales, card_payments etc. The similar columns for all these tables are id, amount, date. How can i query and get below result for a certain customer?
the result what i want: http://imgur.com/a/ZtAFm