The Best was to Dedupe 1

[wilberforce2]

Please help I am having problems with two access tables that I have to dedupe one against the other. Both tables have company names and addresses stored in them.

What I have is a master table (A) and a table with additional information (B).

What I am trying to achieve is a query that checks three fields in both tables fldCompanyName, fldPostCode and fldTelephone and any records not in table A I want added from table B.

Thanks for any suggestions.

 

[AlexCuse]

How about

select b.* from tableB b
left join tableA a
on b.fldCompanyName = a.fldCompanyName
and b.fldPostCode = a.fldPostCode
and b.fldTelephone = a.fldTelephone
where b.fldCompanyName is null

Hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom