select with outer join

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 391,901 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,596 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser:

Thread Tools Display Modes

Views: 2195 | Replies: 1

•

Join Date: Oct 2004

Location: San Francisco, CA

Posts: 337

Reputation: paradox814 is an unknown quantity at this point

Rep Power: 4

Solved Threads: 1

paradox814 paradox814 is offline

Offline

Posting Whiz

select with outer join

Apr 13th, 2006

ok so I have two tables, and I believe I need an outer join

lets say these are them:

Help with Code Tags

(Toggle Plain Text)

 CREATE TABLE t1 (
     xid INT PRIMARY,
     data1 VARCHAR(50) );

CREATE TABLE t2 (
     xid INT PRIMARY,
     data2 VARCHAR(50) );

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.