I'm trying to upgrade from MySQL 4.1 to MySQL 5.0.
A query that works in MySQL 4.1 does not work in MySQL 5.0 and I'm at a loss
as to how to proceed.
SELECT tab_a.item1, tab_b.item2, tab_c.item3, tab_d.item4, tab_e.item5,
tab_f.item6 FROM db.tab_a, db.tab_e, db.tab_f LEFT JOIN db.tab_b ON
At 12:47 PM -0500 7/21/06, Stephen P. Fracek, Jr. wrote:
I'm trying to upgrade from MySQL 4.1 to MySQL 5.0.
A query that works in MySQL 4.1 does not work in MySQL 5.0 and I'm at a loss
as to how to proceed.
SELECT tab_a.item1, tab_b.item2, tab_c.item3, tab_d.item4, tab_e.item5,
tab_f.item6
Stephen P. Fracek, Jr. wrote:
I'm trying to upgrade from MySQL 4.1 to MySQL 5.0.
A query that works in MySQL 4.1 does not work in MySQL 5.0 and I'm at a loss
as to how to proceed.
SELECT tab_a.item1, tab_b.item2, tab_c.item3, tab_d.item4, tab_e.item5,
tab_f.item6 FROM db.tab_a, db.tab_e,
On 2006-07-21 1:01 PM, Gerald L. Clark [EMAIL PROTECTED]
wrote:
It is a join precedence issue. Use INNER Join instead of a comma.
Thanks Gerald.
Paul DuBois' polite suggestion to read the manual helped. Upon re-reading
the section about the change in precedence with
the comma operator and