Re: INNER JOIN order issues.

2009-04-11 Thread Shawn Green
Craig Dunn wrote: 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... SELECTetc INNER JOIN tablex AS x ON y.foo = a.bar INNER JOIN tablea AS a ON y.foo = b.bar ... w

INNER JOIN order issues.

2009-04-07 Thread Craig Dunn
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... SELECTetc 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