Hi
I´m trying to select data from 2 databases within a server.
The user has the correct right to access both databases.
I used
andCode:SELECT db1.tab1.id, db2.tab3.name FROM db1.tab1, db2.tab3
But both times I get: #1103 - Incorrect table name 'db2.tab3', but it is spelled correctly.Code:SELECT table1.id, table3.name FROM db1.tab1 AS table1 db2.tab3 AS table3
Where is my mistake?






Bookmarks