Subtraction sum of 2 tables

[webchambers]

Hi there,

I have a database with 2 tables i am trying to subtract the sum of 1 table column from the sum of the other table column.

I have done this in the the SQL run query (image D1)

and the result i got was (image D2) which is correct

How do i echo this total ?

[benanamen]

Your real problem is your DB design. You should only have one table for income/expenses.