Re: outer joins

yoosh_at_cs.ualberta.ca (Yoo-Shin Lee) writes:

>Hi,
 

>anyone know of any way to do an outer join (full) in oracle?

Oracle supports the standard (?) outer join syntax of SQL:

Select whatever
From table a, table b
where a.primary key += b.foreign key

Hope this helps,

Roeland

Ps: you can also switch the += to =+ (outer join over b)

-- 
// ===========================================================================
// Roeland Loggen (rlogg_at_ctp.com)  After being built and asked "is there a god" 
// Cambridge Technology Partners   the supercomputer replied "well......
// Cambridge MA   (617)-374-8788   there wasn't one, but now there is"