How to join two tables of different db(MSAccess) in Vb6

[krishnasarma]

hi can any one tell me ........how to join two tables of different db(MSAccess) in Vb6 thanx in advance

[fplesco]

hi can any one tell me ........how to join two tables of different db(MSAccess) in Vb6 thanx in advance

Your question is too vague.

But as I see it.

I can give you a sample.

SELECT C.LNAME, C.FIRSTNAME, A.ADDRESS FROM CUSTOMER C INNER JOIN ADDRESSTABLE A ON A.CUSTNO = C.CUSTNO

[Ali Rizwan]

hi can any one tell me ........how to join two tables of different db(MSAccess) in Vb6 thanx in advance

You can also use this code as i m using too and doing good.
data1.Recordset.Find "Date = " & (data)


data1 = Your second table (Dbase)
data = Your first table (Dbase)
if you want to link them with serial numbers or else then add textboxes too and use textbox refrence insteadof data and link textbox to data. it will do good.