InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 05:53:12 GMT20http://www.sqlservercentral.com/Forums/Topic1375360-391-1.aspxUsing the information given you can do something like this[code="sql"]SELECT *FROM OneDatabase.dbo.EmployeeLocation elJOIN SomeDatabase.dbo.Location l ON el.locationcode = l.locationcodeJOIN AnotherDatabase.dbo.Employee e ON el.employeeID = e.employeeID AND l.locationID = e.locationID[/code]You need to change the names of the databases and include the fields that you need insteadof the asterisk.I'm assuming that your databases are on the same server.Mon, 22 Oct 2012 09:06:27 GMTLuis Cazareshttp://www.sqlservercentral.com/Forums/Topic1375360-391-1.aspxYou have to include the database name if the database resides on the same server:[code="sql"]SELECT *FROM MyDatabase.MySchema.MyTable;[/code]That will get it done. You can then join on the appropriate column.Mon, 22 Oct 2012 07:07:35 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1375360-391-1.aspxPlzz follow this: [url]http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url];-)Mon, 22 Oct 2012 06:07:34 GMTEugene Elutinhttp://www.sqlservercentral.com/Forums/Topic1375360-391-1.aspxHi,I have two tables employee(employeeId,LocationID) and employeelocation(employeeId,Locationcode).Both these tables exists in doff database. LocationCode in EmployeeLocation table has char values like XA,Ca etc and in employee table it has ID rather than Code. So how can I put join on these two columns of these two tables. this Location ID and LocationCode is stored in a table Location(LocationID, LocationCode)..plzz give a solutionMon, 22 Oct 2012 06:00:49 GMTkapil_kk