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:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 3:02 AM To: [EMAIL PROTECTED] 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