All pastes #25970 Raw Edit

Miscellany

public text v1 · immutable
#25970 ·published 2005-10-19 15:37 UTC
rendered paste body
select 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