OT: Re: SQL Outer Join Problem (test, off-topic)

Hm, it seems that my newsreader is still sending my e-mail address as th e
author instead of my name.
In alt.test it works however.
Sorry, just a test in this newsgroup (must be a bug in the software).

Marc

>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<

Op 2000-09-01, 7:39:22, schreef <no.email_at_no.spam> over het thema Re: SQ L
Outer Join Problem:

> You can try this:
 

> SELECT *
> FROM etable e,
> (SELECT *
> FROM otable, utable
> WHERE otable.uid = utable.id) o
> WHERE e.oid = o.id(+)
 

> If you have columns in utable with the same name as in otable, you sho
 uld
> alias the column names in the inner select.
 

> Marc
 

> >>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<
 

> Op 2000-08-31, 14:08:31, schreef "Mike DiChiappari" <mike_at_mysticsoft.c
 om>
> over het thema SQL Outer Join Problem:

> > Hello,
 

> > I am having trouble with a query that involves using an outer join.

> > I have three tables: etable, utable, and otable. There are relation
 ships
> > between etable<->otable and otable<->utable. I would like to do an
 outer
> > join between etable and otable so that all records in etable are
 returned,
> > even when a NULL exists in etable's foreign key into otable. So far
 this
 is
> > easy:
 

> > SELECT * FROM etable, otable WHERE etable.oid = otable.id (+) AN
D ...

> > However, in the case where etable.oid is not NULL I would like to do
 a
 join
> > between otable and utable. Note that the following doesn't work (or
 make
> > sense really).
 

> > SELECT * FROM etable, otable, utable WHERE etable.oid = otable.i
 d (+)
 AND
> > otable.uid = utable.id
 

> > Is there a way to do this?
 

> > Thanks,
> > Mike
Received on Fri Sep 01 2000 - 01:03:44 CDT