Error: 1120 - SQLSTATE: 42000 ER_WRONG_OUTER_JOIN
March 11th, 2009
Description:
Message: Cross dependency found in OUTER JOIN; examine your ON conditions
Description:
Message: Cross dependency found in OUTER JOIN; examine your ON conditions
MySql-Server 1120 sql state, how to error:1120 cross dependency found in outer join in mysql, j, lrm-00118: syntax error at '=' at the end of input
Make sure that you DON’T use a table before it is being joined. Check if your query has any out-of-order joins. This error might occur when trying to join one particular table that is corrupted or has some inconsistencies in backend. Drop the table and recreate it.