SELECT Query across multiple databases
Okay, I'm using Microsoft SQL Server 7.0. I have a database repository of Users that I want to be used by multiple sites. However, today I realized that some tables from the databases for the other sites need to link by UserID to the repository database. For example, I need to get a list of documents posted by particular users. I know that if they were in the same database I could just do:
Is there a way to do this by specifying the database? Or do I have to do something else.
SELECT * FROM Documents D INNER JOIN Users U ON U.UserID = D.UserID