Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pmak
Starting Member
41 Posts |
 Posted - 2006-04-11 : 14:26:52
|
| I need to create a data source from two tables reside on two seperate databases for a parameter on a report. This tables can be linked together with a Primary Key field on one table and Secondary Key field on the other. Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-04-11 : 14:31:54
|
| Are both databases on the same server? If so, then you can do this in the query using the 3 part naming convention for the remote object.SELECT ...FROM dbo.Table1 t1INNER JOIN SomeOtherDB.dbo.Table99 t2...Tara Kizeraka tduggan |
 |
|
|
|
|
|
How to create a data source from two database