Dear all,
I've got a query that does a LEFT JOIN.
Something like this:
SELECT a.id, myB.someField, c.someColumn
FROM c, a
LEFT JOIN b AS myB ON (myB.id = a.id)
which works.
However, if I reverse the two tables in the FROM clause, it doesn't work anymore. It seems like the table in the ON part...