Hi

Im trying to select data from 2 databases within a server.
The user has the correct right to access both databases.

I used

Code:
SELECT 
  db1.tab1.id,
  db2.tab3.name
FROM
  db1.tab1,
  db2.tab3
and

Code:
SELECT 
  table1.id,
  table3.name
FROM
  db1.tab1 AS table1
  db2.tab3 AS table3
But both times I get: #1103 - Incorrect table name 'db2.tab3', but it is spelled correctly.

Where is my mistake?