MySQL Forums
Forum List  »  PHP

try to get monthly report of donation and expenses of charity organization
Posted by: Saif Rehman
Date: May 08, 2016 06:26PM

I have two tables called expenses and donation

Table 1

expenses

s.no expensedate expense

1 13/01/16 30

2 15/01/16 60


Table 2

s.no donationdate donation

15 14/01/16 30

18 19/01/16 10



Out Put required

Month Expense Donation

Jan 90 40


I can get the output individually like

Month expense

jan 90

or

Month donation

jan 40


but cannot join them together, such a way it could give required output.

thx

Options: ReplyQuote


Subject
Written By
Posted
try to get monthly report of donation and expenses of charity organization
May 08, 2016 06:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.