RE: [PHP-DB] sql querry problem

2002-05-03 Thread Ryan Jameson (USA)
IL PROTECTED]] Sent: Friday, 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 PROTEC

Re: [PHP-DB] sql querry problem

2002-05-03 Thread szii
"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

RE: [PHP-DB] sql querry problem

2002-05-03 Thread Ryan Jameson (USA)
ginal 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 con

[PHP-DB] sql querry problem

2002-05-03 Thread andy
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.