Delete Query

[MTSPEER]

Hello guys, I'm trying to make a delete query where I have two tables, PGMF and LICS. They are joined by the field Group_Number. I just want to make a delete query to delete the unmatched groupnumbers in the LICS table from the PGMF table. Thank you

[JoeM]

This should do it:

DELETE LICS.*
FROM LICS
WHERE LICS.GROUP_NUMBER NOT IN 
(SELECT PGMF.GROUP_NUMBER
FROM PGMF);

[MTSPEER]

Thanks Joe! I actually just figured it out before I checked your post. but thank you!