Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Selecting from joined tables (simple question)
"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 >
Congrats, you found it. Use an outer join. Received on Thu Jan 29 2004 - 07:12:25 CST