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