Please support our MySQL advertiser: Programming Forums
Views: 2752 | Replies: 1
 |
•
•
Join Date: Oct 2004
Location: San Francisco, CA
Posts: 338
Reputation: 
Rep Power: 5
Solved Threads: 2
Posting Whiz
select with outer join ok so I have two tables, and I believe I need an outer join
lets say these are them: so here is an explanation of the tables
t1.xid = t2.xid
for every row in t1.xid, there is a guaranteed matching t2.xid, but the same in not true in reverse
now I want to do somthing like this:
SELECT t1.xid, t1.data1, t2.data2
FROM t1,t2
WHERE t1.xid=t2.xid
but I want it to select EVERY row in t1 AND t2 even if a row does not exsist in both tables
Thanks.
lets say these are them:
CREATE TABLE t1 (
xid INT PRIMARY,
data1 VARCHAR(50) );
CREATE TABLE t2 (
xid INT PRIMARY,
data2 VARCHAR(50) );t1.xid = t2.xid
for every row in t1.xid, there is a guaranteed matching t2.xid, but the same in not true in reverse
now I want to do somthing like this:
SELECT t1.xid, t1.data1, t2.data2
FROM t1,t2
WHERE t1.xid=t2.xid
but I want it to select EVERY row in t1 AND t2 even if a row does not exsist in both tables
Thanks.
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 482
Reputation:
Rep Power: 4
Solved Threads: 19
Posting Pro in Training
don't use mysql buth this works in ms-sql:
select t1.xid,t1.data1, t2.data2 from t1
right join t2 on
t1.xid = t2.xid
select t1.xid,t1.data1, t2.data2 from t1
right join t2 on
t1.xid = t2.xid
Last edited by campkev : Apr 19th, 2006 at 2:23 pm. Reason: correction
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
