hayal.et hayal.et - 5 months ago 67
PHP Question

MySQL select * from table1,table2 as 'test'

I have a problem in MySQL.

Select table1.column1,test.column2 from table1,table2 as test inner join table3 on table3.column3=table1.column1 where test.column2=table1.column1


I get this error : Unknown column 'table1.column1' in 'on clause'

Answer

if you use few tables in FROM you must use ():

from (table1,table2)

Comments