rendered paste bodyselect e.date, e.amount, w. date, w.amount
from useroutcome w, userincome e
where w.accountid = '1'
and e.accountid = w.accountid;
-
Response I get:
date amount date amount
2005-10-10 00:00:00 150 2005-11-11 00:00:00 10
2005-10-10 00:00:00 150 2004-00-00 00:00:00 70
2005-10-10 00:00:00 150 2005-11-08 00:00:00 40
2005-11-06 00:00:00 20 2005-11-11 00:00:00 10
2005-11-06 00:00:00 20 2004-00-00 00:00:00 70
2005-11-06 00:00:00 20 2005-11-08 00:00:00 40
2005-12-12 00:00:00 50 2005-11-11 00:00:00 10
2005-12-12 00:00:00 50 2004-00-00 00:00:00 70
2005-12-12 00:00:00 50 2005-11-08 00:00:00 40
-
SELECT date, amount FROM userincome where accountid = '1';
date amount
2005-10-10 00:00:00 150
2005-11-06 00:00:00 20
2005-12-12 00:00:00 50
-
SELECT date, amount FROM useroutcome where accountid = '1';
date amount
2005-11-11 00:00:00 10
2004-00-00 00:00:00 70
2005-11-08 00:00:00 40