Joining tables from different Databases.
Dear Friends.
Select Emp.EmployeeCode, Emp.EmployeeName,Emp.DeptCode,Dept.DepartmentName
From Emp,Dept
Where Emp.DeptCode = Dept.DeptCode.
In this query Emp table lying in the Database_1, and Dept table tying in Database_2.
How i run this query in VB by using ADODB Connectivity. how i write the connection,lockType after the query; ie
rs.op 'sql......................' ? , ? , ?
I want to insert the result in another table that is in Database_3
how many databases connections i have to make ?. pl advise
Thanks
Bobby