how to delete matched records?

[Geoff Cox]

Hello,

I have table A with say 200 names in it and a second table B with say
40 names in it.

I would like to compare the 2 tables and delete in A any name which
appears in B.

How to do this?!

Cheers

Geoff

 

[Pieter Wijnen]

DELETE From A
WHERE Exists (Select 'X' From B WHERE B.LinkField=A.LinkField)

Pieter

 

[Dale Fye]

Are you absolutely certain that "John Doe" in table A is the same person as
"John Doe" in table B, or is that Jonathan Doe in table B?

You've got to be careful doing this type of thing with a query. When you
are using ID values that is one thing, but any time you compare names you
have to be careful that you use some other parameter (phone, address, dob,
....) as well to do the matching (if you have one) .

Dale

 

[Geoff Cox]

DELETE From A
WHERE Exists (Select 'X' From B WHERE B.LinkField=A.LinkField)

Thanks Pieter,

being new at this - how do I implement the above?!

Cheers

Geoff

 

[Geoff Cox]

DELETE From A
WHERE Exists (Select 'X' From B WHERE B.LinkField=A.LinkField)

Pieter,

I should also ask what 'X' is?

Presumably LinkField is the name of the field with the names in it?

Cheers

Geoff

 

[Geoff Cox]

DELETE From A
WHERE Exists (Select 'X' From B WHERE B.LinkField=A.LinkField)

Pieter,

I have got it working so many thanks.

I had to use [A] etc then it was OK.

Cheers

Geoff