Michael Griffith wrote:
> I read in one of the messages on the list posted by Monty that when
> processing a LEFT JOIN, mysql moves the ON clause to the WHERE clause.
> I like to use the LEFT JOIN ... ON syntax for easier reading when I write
> complicated queries, but many times I cannot get a query to work unless I
> move the ON clause to the WHERE clause myself. Sorry I don't have a specific
> In other words, can anyone give a definitive answer on what is the
> difference between these two queries:
> 1) SELECT * FROM a,b WHERE a.id = b.id
> 2) SELECT * FROM a LEFT JOIN b ON a.id = b.id
> In a statement as simple as this, I always get the same output, but when I
> add in a few more JOINS, sometimes I get different output.
Could you provide a full example?