SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="d:\db1.mdb";Jet OLEDB:Database Password=12345;User id=;password=;')...表名1 as a
where exists(select 1
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="d:\db1.mdb";Jet OLEDB:Database Password=12345;User id=;password=;')...表名2 as b where a.id = b.id)
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="d:\db1.mdb";Jet OLEDB:Database Password=12345;User id=;password=;')...表名1 as a
where exists(select 1
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="d:\db1.mdb";Jet OLEDB:Database Password=12345;User id=;password=;')...表名2 as b where a.id = b.id)
INNER JOIN tb as b
ON a.phone=b.phone这样得出的phone就是二个access表中重复的phone
select a.phone from ta as a,tb as b where a.phone=b.phone