Hi,
If I recall it right the statement should be following:
DELETE FROM Contract_Table, Client_Table WHERE contract_client_id =
client_id
AND client_contact = 'corricello' AND contract_percent = 0;
Thanks,
James R. Butzen
[EMAIL PROTECTED]
NEBIS Tech Support
http://www.nebis.com
-----Original Message-----
From: Daevid Vincent [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 3:41 PM
To: mySQL Database
Subject: how do I delete using a join in mySQL?
hey, how do I DELETE all these Contract_Table records in mySQL?
SELECT contract_id, client_contact, contract_percent
FROM Contract_Table, Client_Table
WHERE contract_client_id = client_id
AND client_contact = 'corricello' AND contract_percent = 0;
I see this page, but didn't know if it was dated or not:
http://www.mysql.com/doc/D/e/Deleting_from_related_tables.html
Does v3.23 support this if v3.22 doesn't?
daevid.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
