- Original Message -
From: "Ben Liu" <[EMAIL PROTECTED]>
To:
Sent: Thursday, June 14, 2007 3:11 PM
Subject: 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
Thanks Brent, good tip. Works like a charm.
On Jun 14, 2007, at 7:42 PM, Brent Baisley wrote:
Here's a little trick. Get your DELETE query working as a SELECT.
Then replace everything before FROM with DELETE tablename.
SELECT order_items.ord_id FROM order_items LEFT JOIN orders ON
order_item
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
At 10:40 -0400 6/25/02, Peter M. Perchansky wrote:
>Greetings:
>
>Thanks to Jay from this list and doing some reading, I resolved the
>insert issue when trying to insert records using a select where the
>tables are the same.
>
>Now I'm trying to clean up the old records, and no matter what
>del
Greetings:
Thanks to Jay from this list and doing some reading, I resolved the insert
issue when trying to insert records using a select where the tables are the
same.
Now I'm trying to clean up the old records, and no matter what delete
statement I try, it fails:
DELETE FROM Customer_Equip
