Hi,
I'm trying to migrate an application from 4.1 to 5.1, theres a bunch of
queries that seem to be failing and it looks like the order of INNER
JOIN's... for example...
SELECT....etc
INNER JOIN tablex AS x ON y.foo = a.bar
INNER JOIN tablea AS a ON y.foo = b.bar
... works in 4.1, but in 5.1 I get unknown column a.bar, but if I switch
the order of these joins around it works fine. Is this a known
compatibility issue between the major versions? and is there a work
around apart from changing the SQL (which we're trying to avoid where
possible!)
Cheers
Craig
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
