Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Selecting from joined tables (simple question)

Re: Selecting from joined tables (simple question)

From: Guido Konsolke <GK_at_oblivion.com>
Date: Thu, 29 Jan 2004 14:12:25 +0100
Message-ID: <1075380700.118909@news.thyssen.com>


"willy_gates" wrote...
> > something like this?
> >
> > select ds.id from DATA_STANDARD ds, DATA_EXTRA de
> > where
> > ( ds.id not in ( select DS_ID from DATA_EXTRA ) )
> > or
> > (
> > --Join
> > ( ds.id = de.DS_ID )
> > and
> > ( de.extra_value is null )
> > )
> >
> > Why is this wrong?

>
> I still don't know but I suppose I should be using an OUTER JOIN
>

> >
> > Thanks

Congrats, you found it. Use an outer join. Received on Thu Jan 29 2004 - 07:12:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US