ITG Holding interview question

Technical Interview: Can you join tables between different databases ? How?

Interview Answer

Anonymous

28 Mar 2018

YES, SELECT a.userID, b.usersFirstName, b.usersLastName FROM databaseA.dbo.TableA a inner join database B.dbo.TableB b ON a.userID=b.userID