Query on multiple database in QueryBuilder

  • Thread starter Thread starter RichardDunneBSc
  • Start date Start date
R

RichardDunneBSc

Guest
I am trying to do a query on 2 databases involving 3 tables. How do I reference the column in the second database? I have

select column
from tableName as t, DatabaseName.column as d,

I'm getting invalid object name DatabaseName.column. Also, I tried Query Builder but there is no option for selecting another database.

Continue reading...
 

Similar threads

D
Replies
0
Views
934
Dante Havenaar
D
D
Replies
0
Views
710
Dante Havenaar
D
D
Replies
0
Views
326
Dante Havenaar
D
J
Replies
0
Views
208
John_tay
J
Back
Top