* 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]

Reply via email to