RE: [PHP-DB] sql querry problem

the ansi syntax for delete is "delete from table where ???" You don't tell it what to delete since it will always delete whole rows. So just remove o.* . If you are in need of setting a field to blank you'll have to use an update, not a delete. <>< Ryan -----Original Message----- From: andy [mailto:news.letters@gmx.de] Sent: Friday, May 03, 2002 3:02 AM To: php-db@lists.php.net 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