I have two tables. Payment and expense.
1. select sum(amount) from payment
gives me total payment amount
2. select sum(amount) from expense
gives me total expense.
3. I want to join payment and expense table. How can i subtract query1 minus query2 in one join query?