rendered paste body
desc userincome;
Field Type Null Key Default Extra
id int(11) PRI NULL auto_increment
accountid int(11) 0
name varchar(25)
address varchar(25)
city varchar(25)
state varchar(25)
zip varchar(25)
countryid int(11) 0
phoneno varchar(25)
faxno varchar(25)
amount int(11) 0
currencyid int(11) 0
paymenttypeid int(11) 0
cardtypeid int(11) 0
ccardno varchar(25)
ccardexpdate varchar(25)
bankname varchar(25)
bankphone varchar(25)
signature varchar(25)
date datetime 0000-00-00 00:00:00
senderid int(11) 0
desc useroutcome;
Field Type Null Key Default Extra
id int(11) PRI NULL auto_increment
accountid int(11) 0
name varchar(25)
address varchar(25)
city varchar(25)
state varchar(25)
zip varchar(25)
countryid int(11) 0
phoneno varchar(25)
faxno varchar(25)
amount int(11) 0
currencyid int(11) 0
paymenttypeid int(11) 0
cardtypeid int(11) 0
ccardno varchar(25)
ccardexpdate varchar(25)
bankname varchar(25)
bankphone varchar(25)
signature varchar(25)
date datetime 0000-00-00 00:00:00
recipientid int(11) 0
-----------------------------------------------
SELECT e.id, e.date, e.amount, w.id, w.date, w.amount
FROM useroutcome w, userincome e
WHERE w.nonresaccountid = '1'
AND e.accountid = w.accountid;
id date amount id date amount
1 2005-10-10 00:00:00 150 1 2005-11-11 00:00:00 10
1 2005-10-10 00:00:00 150 3 2004-00-00 00:00:00 70
1 2005-10-10 00:00:00 150 4 2005-11-08 00:00:00 40
4 2005-11-06 00:00:00 20 1 2005-11-11 00:00:00 10
4 2005-11-06 00:00:00 20 3 2004-00-00 00:00:00 70
4 2005-11-06 00:00:00 20 4 2005-11-08 00:00:00 40
5 2005-12-12 00:00:00 50 1 2005-11-11 00:00:00 10
5 2005-12-12 00:00:00 50 3 2004-00-00 00:00:00 70
5 2005-12-12 00:00:00 50 4 2005-11-08 00:00:00 40
-------------------------------------
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