> > * 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 > WHERE....live > > > > an learn I guess. > > > > > > Ehm, I'm not completely sure, but isn't this invalid behaviour? > > > > 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 optional, and INNER is default - right?
Right... been doing some more checking. It makes totally sense - I misread the first report. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]