Re: JOIN problem

Hi Michael,

This:

SELECT ta.* FROM ta, tc LEFT JOIN tb ON tb.tb_id = ta.ta_id;
ERROR 1054 (42S22): Unknown column 'ta.ta_id' in 'on clause'

is not a bug, but a result of changing JOIN behaviour in 5.0.12 and 
following versions. Please, read the manual, 
http://dev.mysql.com/doc/refman/5.0/en/join.html:

" However, the precedence of the comma operator is less than than of INNER 
JOIN, CROSS JOIN, LEFT JOIN, and so on. If you mix comma joins with the 
other join types when there is a join condition, an error of the form 
Unknown column 'col_name' in 'on clause' may occur."

Best regards,
-- 
Valeriy Kravchuk, Support Engineer
MySQL AB, Kiev, Ukraine, www.mysql.com

Are you MySQL certified?  www.mysql.com/certification 


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]