That too... :-) You'll have to do two deletes, if your referential integrity is set up you'll have to delete the children before you can delete the parent as well. Thanks Szii.. I missed that part.
<>< Ryan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 11:48 AM To: andy Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] sql querry problem "Delete from" does not work with multiple tables, AFAIK.. -Szii ----- Original Message ----- From: "andy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 03, 2002 2:02 AM Subject: [PHP-DB] sql querry problem > Hi there, > > I do have 2 tables. One contains an update for the other one. Before > inserting I would like to delete all the entries in the old table containing > the same country_code like one in the new table. > > I tryed: > > delete o.* > from Cities_update_imported n, test.cities o > where n.country_code = o.country_code > > But does not work though:-( > > can anybody help on that? > > thanx, Andy > > > > > -- > 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
