2 years ago

showing the extract of an account

Posted 2 years ago by halil

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

Please sign in or create an account to participate in this conversation.