Re: need help with delete query

2007-06-14 Thread Ben Liu
h I'm 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

need help with delete query

2007-06-14 Thread Ben Liu
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: Find ids that are NOT in other two tables.

2006-05-22 Thread Ben Liu
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 wor