Hope somebody can help me on this one.... At present I have two tables in my database. The data in question is built around credit card transactions.
Tables Structure Headers Table ID (Primary Key used by the TRANSACTIONID field in the Transaction table) HEADERDETAILS blah, blah Transaction Table ID (Primary Key) TRANSACTIONID (Foreign Key into the Headers table) TRANSACTIONDETAILS blah,blah TRANSACTIONDATE I wish to delete all records from the headers table for a given date AND the associated records in the transaction table. After looking through the MySQL manual I discovered that deleting from multiple tables using a join is not supported. Has anybody any ideas I can use to remove the data ??????? (and some REAL life queries cause I`m still just a beginner :)) p.s. If this is not clear please say so and I will elaborate :) ******************************************************************************************** " This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst & Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message ". ******************************************************************************************** --------------------------------------------------------------------- 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
