Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
All-Star
16526 Points
3378 Posts
Feb 15, 2012 04:12 PM|LINK
Do the databases reside in the same instance of SQL Server? If so you can do something like this:
SELECT t1.*, t2.column2 FROM DB1.dbo.T1 t1 INNER JOIN DB2.dbo.T1 t2 ON t2.ID = t1.ID
stevenbey
All-Star
16526 Points
3378 Posts
Re: Two databases, two tables, merge datasets into GridView
Feb 15, 2012 04:12 PM|LINK
Do the databases reside in the same instance of SQL Server? If so you can do something like this:
http://stevenbey.com
Recursion: see Recursion