* Martijn Tonies
> * me
> > Huh? What would be invalid about it?
>
> That moving parts of the WHERE clause to the JOIN clause returns
> a different result set. But as I said: I don't have the full story ... oh
> wait, I found the first message in my mailbox somewhere.
>
> I guess "OUTER" is opti
> > * Martijn Tonies
> > > * Rory McKinley
> > > > Thanks Roger
> > > >
> > > > That fixed the problem.I was under the impression that I only
had
> to
> > > > put the linked columns n the ON and everything else in the
> WHERElive
> > > > an learn I guess.
> > >
> > > Ehm, I'm not completel
> * Martijn Tonies
> > * Rory McKinley
> > > Thanks Roger
> > >
> > > That fixed the problem.I was under the impression that I only had
to
> > > put the linked columns n the ON and everything else in the
WHERElive
> > > an learn I guess.
> >
> > Ehm, I'm not completely sure, but isn't th
* Martijn Tonies
> * Rory McKinley
> > Thanks Roger
> >
> > That fixed the problem.I was under the impression that I only had to
> > put the linked columns n the ON and everything else in the WHERElive
> > an learn I guess.
>
> Ehm, I'm not completely sure, but isn't this invalid behaviour?
> Thanks Roger
>
> That fixed the problem.I was under the impression that I only had to
put
> the linked columns n the ON and everything else in the WHERElive an
> learn I guess.
Ehm, I'm not completely sure, but isn't this invalid behaviour? Can you post
the DDL and INSERT INTO data for
Thanks Roger
That fixed the problem.I was under the impression that I only had to put
the linked columns n the ON and everything else in the WHERElive an
learn I guess.
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL PROTECTED]
"There are 10 kinds of people in this world,
those who