MartinSmithhh
Programmer
Does any one know how to do this?
I am currently trying the following
SELECT *
FROM DB1.Table1, DB2.Table1
WHERE (DB1.Table1.NT_Login = DB2.Table1.NT_domain_login)
And getting this error
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'DB1.Table1'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'DB2.Table1'.
I am currently trying the following
SELECT *
FROM DB1.Table1, DB2.Table1
WHERE (DB1.Table1.NT_Login = DB2.Table1.NT_domain_login)
And getting this error
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'DB1.Table1'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'DB2.Table1'.