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