Tag Archives: unknown column

Joins in MySQL 5: #1054 – Unknown column ‘…’ in ‘on clause’

If you used to write MySQL joins for MySQL versions < 5.0 or upgrade your server from MySQL 4 to MySQL >= 5.0 you maybe run into a problem when you execute the following query: SELECT * FROM mytable1, mytable2 … Continue reading

Posted in Join Hints | Tagged , , , , | 3 Comments