Combine two DB/RS

<i><b>Originally posted by : Raphel (raphel.girma@foveon.net)</b></i><br /><br />I have MS Access and SQL Server databases both have to track Employees inf for various uses.I have employees table in both DB that have identical EmpID. Based on this how can I write ASP code that access both databases and do SELECT from this two DBs to display employee inf.<br />How to setup two ODBC connections, two recordsets and do joins.<br /><br />ex. select * from EmployeeAccessTable, EmployeeSqlServerTable where EmployeeAccessTable.empid = EmployeeSqlServerTable.empid