I am new to using sql .i have two table expense statement and revenue statement such as
is there anyway i can join these two table like this, if so can someome tell me how to do it please.
accountname debit credit
I have tried this sattement but it doesnot work
SELECT accountname, NULL AS debit, credit FROM revenue
SELECT accountname, debit, NULL FROM expense