ERROR 1054 Unknown column 't1' in 'on clause'

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

ERROR 1054 Unknown column 't1' in 'on clause'

Postby BramN » 25. June 2006 15:21

After the installation of a CMS on XAMPP local host, I encountered a problem with MySQL which does not appear in installations on other hosts using other versions of MySQL.

After some investigations it was found that in the statement:

SELECT ..... FROM (t1,t2) LEFT JOIN t3 ON t3.a=t1.a WHERE ....

the parenthesis are mandatory, where other versions of MySQL are clearly more tolerant and do not require the parenthesis in this statement. :o
BramN
 
Posts: 1
Joined: 25. June 2006 14:27
Location: Noordoostpolder (NL)

Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 1 guest