"Delete from" does not work with multiple tables, AFAIK..
----- 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. 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