I changed my tables to use foreign key constraints with on delete cascade
and that did what I needed.
Thanks,
David Ruggles
CCNA MCSE (NT) CNA A+
Network EngineerSafe Data, Inc.
(910) 285-7200 [EMAIL PROTECTED]
-Original Message-
From: David Ruggles [mailto:[EMAIL PROTECTED]
Bhavin,
Saturday, June 15, 2002, 2:36:07 AM, you wrote:
BV Just wanted to make sure before I proceed to write a script,
BV Muti-table deletes as such:
BV delete from Keyname_Keyvalue,Keyvalue WHERE
BV Keyvalue.KeyvalueKey=Keyname_Keyvalue.KeyvalueKey AND
BV Keyname_Keyvalue.KeynameKey='100';