Delete Query Question

[Madmax]

Good Morning,
I am trying to write a Query that will check to see if TBL_PTWEB has a matching record in TBL_PTID. The primary key and relationship is DBPTID Field. I couldnt get cascade to work so I am at this point. I have deleted the person from TBL_PTID(Based off out-process date) but I dont know how to tell the query to both run an unmatched query and a delete query. Would it be easier just to take the SQL from both a delete and match query and attempt to mix it up? I suck at SQL lol



--MadMax

[Madmax]

Nevermind worked around it. Made a form from the select query and will just manually delete works great to see if anyone is missed during in-processing anyways