need help with delete query

I'm trying to delete a subset of items in a table. The problem is, I don't want to query for the subset first, store the results and then run a series of delete queries. I believe this is a rather basic issue that has a well-accepted, simple solution which I am ignorant of. There are two relevant

Re: need help with delete query

pretty sure it's covered in the manual. On 6/14/07, Ben Liu [EMAIL PROTECTED] wrote: I'm trying to delete a subset of items in a table. The problem is, I don't want to query for the subset first, store the results and then run a series of delete queries. I believe this is a rather basic issue

Re: Find ids that are NOT in other two tables.

Uh, I don't have anything to add to this thread except that this was the *exact* problem I was trying to solve and this really helped me a lot. Thanks guys. -BL On 5/22/06, Jay Pipes [EMAIL PROTECTED] wrote: Yesmin Patwary wrote: Hi, Greatly appreciated your kind help. Would it work,