joining tables from different databases

[nights]

hi! i'm just a newbie with php and mysql... and i'm having problems joining tables from different databases...

can you please help me? here's my query:

SELECT database1.table1.field1, database1.table1.field2,
database1.table1.field3,
database1.table1.field4,
database1.table1.field5,
database2.table1.field1,
database2.table1.field2

FROM
database1.table1,
database2.table1

LEFT JOIN
database1.table1

ON
database2.table1.field1 = database1.table1.field1

WHERE database1.table1.field2 LIKE 'condition'


my query result says: Not unique table/alias: 'table2'

thanks in advance! ^_^

[ronverdonk]

hi! i'm just a newbie with php and mysql... and i'm having problems joining tables from different databases...

can you please help me? here's my query:

SELECT database1.table1.field1, database1.table1.field2,
database1.table1.field3,
database1.table1.field4,
database1.table1.field5,
database2.table1.field1,
database2.table1.field2

FROM
database1.table1,
database2.table1

LEFT JOIN
database1.table1

ON
database2.table1.field1 = database1.table1.field1

WHERE database1.table1.field2 LIKE 'condition'


my query result says: Not unique table/alias: 'table2'

thanks in advance! ^_^

You have an error in the code you show. According to the error message you have a table2 in there. In your posted code there is no table2 to be seen.

Ronald :cool: