[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 =

RE: [PHP-DB] sql querry problem

[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

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

RE: [PHP-DB] sql querry problem

, 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