Technical Interview: Can you join tables between different databases ? How?
Anonymous
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
Check out your Company Bowl for anonymous work chats.