i have few tables
table :sale, invoice, payment
all of them have :date , payby (cash/cheque) , currency
what should i do to join them(currency) up and group by month ?
or become this :
query - cash
___________| Cash |Invoice |Payment
2007 Jan____| $$$$$$ | $$$$$$...