Hi Paul,
Thanks for the reply.
I actually need to delete data from about 10 tables, is this possible?
From: "Paul McNeil" <[EMAIL PROTECTED]> To: "shaun thornburgh" <[EMAIL PROTECTED]> Subject: RE: DELETE from more than one table Date: Mon, 7 Jun 2004 08:47:04 -0400
I believe you can use...
Delete from TableA join TableB ON TableA.data = TableB.data WHERE TableA.otherData = myNeeds.
GOD BLESS AMERICA! To God Be The Glory!
-----Original Message----- From: shaun thornburgh [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 8:37 AM To: [EMAIL PROTECTED] Subject: DELETE from more than one table
Hi,
Is it possible to DELETE from more than one table in one command?
Thanks for your help
_________________________________________________________________ Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]