I'm sure there's already one if not several posts for this but I couldn't
any. I have two tables both the same serial code field. I want to a basic
delete from tableA where tableA and tableB have matching serial codes. I have
tried just joining the two table by the serial code field in a delete query
but no matter how I try to go about it nothing works.

Thanks in advance for any assistance you can provide on this issue.

DBGuy11

DELETE FROM tableA
WHERE tableA.SerialCode IN (SELECT DISTINCT SerialCode FROM tableB)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"DBGuy11" <(E-Mail Removed)> wrote in message
news:26CA7107-258F-41DC-97EE-(E-Mail Removed)...
> I'm sure there's already one if not several posts for this but I couldn't
> any. I have two tables both the same serial code field. I want to a basic
> delete from tableA where tableA and tableB have matching serial codes. I
> have
> tried just joining the two table by the serial code field in a delete
> query
> but no matter how I try to go about it nothing works.
>
> Thanks in advance for any assistance you can provide on this issue.
>
> DBGuy11