this solution will not work for mysql databases, as mysql does not support sub-selects
-----Original Message----- From: Bill Morrow [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 2:02 PM To: Andr?s Felipe Hern?ndez Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] delete statement question On Mon, Mar 25, 2002 at 02:42:08PM -0800, Andr?s Felipe Hern?ndez wrote: > Hi, I hope you can help me with this: > > I have these 3 tables. > > exam ( > exam_id > ) > > questions ( > question_id > exam_id > ) > > answers ( > answer_id > question_id > ) > > I am wondering if i can delete all the rows for answers linked to a given > exam using only one delete statement. > > Thanks in advance, > > andres > delete answers where question_id in (select question_id from questions where exam_id=X) I assume there isn't a one-to-one relationship between questions and answers? If there is, your database is overnormalized. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php