Is there any query code that will allow joining tables that are in different databases running on the same server If yes, how is the connection to each handled
Query 2 tables - each in a different database
Hot Topic
- Error 18452 (not associated with a trusted sql server connection)
- Unable to connect to Analysis Services as a client
- Merge replication fails
- I cant deploy
- Login failed for ".
- F I L T E R HELP!!! PLEASE!!!! THIS CAN'T BE THAT HARD
- SQL 2005 DB design
- WebParts not found for Reporting Services
- Distributed Transaction Persistent Error
- DataReader Destination Adapter Error!!!
SQL Server
- Stuck between "Failed to generate user instance" and "An attempt to attach...failed"
- UK Datetime parameter problem SQL 2005 RS
- ReportService2005 and ReportExecution2005
- SQL Server 2005 incorrectly claims I don't meet minimum service pack level requirements?
- SS2005 re-download
- I'm Stumped (Complex Joins With and Updates)
- Securing the Data of Tables
- DataBase Connection
- Report Builder fatal error
- Why isn't there a MS Access Forum?????
Query 2 tables - each in a different database
Bad_Bob
The select code is clear but the connection to the two databases is not when using ADO. Is one connection object used somehow or are the databases linked
draxx
That is no problem.
SELECT a.Field, b.Field
FROM dbo.myTable a
JOIN OtherDatabase.dbo.myTable b ON a.myKey = b.myKey
Aquind
WeslyB is right.
But your user has to have select rights on the other database.
You don't have to handle the rights in ADO.
Regards