* 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 optional, and INNER is default - right?
This was a LEFT JOIN... :) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]