"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
