Hi,
I need to create a sql select statement which join 2 databases, where both the database have to connect with different port numbers,
db1 port: 3306
db2 port: 3311
select something from db1.table1 A left join db2.table2 B on A.id = B.id
when i execute it, the error msg come out:
SELECT command denied to user 'username'@'localhost' for table 'table1'
I need to solve it urgently, all helps will be appreciated
Thanks in advanced.
Yii Ing
You can SELECT different tables but the tables must exist within ONE
logical database, not from two or more logical databases.
Ronald :cool: