Assuming your both databases (Login and World) are in same server you can use like
USE [Login]
GO
SELECT *
FROM dbo.Accounts a
INNER JOIN World.dbo.Characters c
ON c.Owner = a.Username
But IMO there's no need for separate dbs. You can keep the tables in the same database as there's no other settings that you need to apply separately for them
In that case the above query reduces to
SELECT *
FROM dbo.Accounts a
INNER JOIN dbo.Characters c
ON c.Owner = a.Username
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Help me set up a database structure
Posted - 10/20/2013 : 02:54:35
