Results 1 to 3 of 3
Thread: SELECT across 2 Databases
Jan 27, 2006, 10:52 #1
- Join Date
- Oct 2003
- 0 Post(s)
- 0 Thread(s)
SELECT across 2 Databases
I´m trying to select data from 2 databases within a server.
The user has the correct right to access both databases.
SELECT db1.tab1.id, db2.tab3.name FROM db1.tab1, db2.tab3
SELECT table1.id, table3.name FROM db1.tab1 AS table1 db2.tab3 AS table3
Where is my mistake?