Re: [SOLVED]Re: LEFT JOIN problem

2003-11-20 Thread Roger Baklund
* 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

Re: [SOLVED]Re: LEFT JOIN problem

2003-11-20 Thread Martijn Tonies
> > * 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

Re: [SOLVED]Re: LEFT JOIN problem

2003-11-20 Thread Martijn Tonies
> * 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

Re: [SOLVED]Re: LEFT JOIN problem

2003-11-20 Thread Roger Baklund
* 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?

Re: [SOLVED]Re: LEFT JOIN problem

2003-11-20 Thread Martijn Tonies
> 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

[SOLVED]Re: LEFT JOIN problem

2003-11-20 Thread Nobody
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