L
Lurc
Hi all,
I need to query data from at least 2 MDB files that have a common CardNo
field. The tables that hold those info are in different MDBs, how can I
run select SQL statement under VB.NET environment?
For example:
In A.MDB, table CardInfo has fields CardNo and Name
In B.MDB, table Record has fields CardNo, Date, Controller
So what is the select phrase like,
Select
[a.cardinfo.cardno],[a.cardinfo.name],[b.record.date],[b.record.controller]
From [a.cardinfo],[b.record]
where [a.cardinfo.cardno]=[b.record.cardno]
Thanks.
I need to query data from at least 2 MDB files that have a common CardNo
field. The tables that hold those info are in different MDBs, how can I
run select SQL statement under VB.NET environment?
For example:
In A.MDB, table CardInfo has fields CardNo and Name
In B.MDB, table Record has fields CardNo, Date, Controller
So what is the select phrase like,
Select
[a.cardinfo.cardno],[a.cardinfo.name],[b.record.date],[b.record.controller]
From [a.cardinfo],[b.record]
where [a.cardinfo.cardno]=[b.record.cardno]
Thanks.