query on multiple databases

Question

User-220722638 posted

How do i query into multiple database and return results based on SSN? I am using visual studio and i have connection string for SQL and Access in webconfig.

Access:
Database Name: User data.mdb
table: UserInformation
field: SSN
field: Dept

SQL:
Database name: sql2.UserTracking.dbo
table: User_Info
field:SSNO
field: FIRST NAME

Answer 1

User-1407477457 posted

Set up linked tables to the sql db in your access db.

Answer 2

User-808732501 posted

select  *
from    User data.dbo.UserInformation as t1
inner join
        sql2.UserTracking.dbo.User_Info as t2
on      t1.SSN = t2.SSNO