How to write this querry?
| From: | Andy | Date: | Sun, 30 Dec 2001 20:55:03 +0000 |
| Subject: | How to write this querry? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15275@lists.php.net to get a copy of this message | ||
Hi guys,
I am trying to get rid of not needed data.
There is a table called provinces containing country_codes and province_id
Another table contains the cities with the field province_id
How can I get rid of cities which are not listed with a province_id in the
table provinces?
I tryed something like that:
delete from cities
where NOT cities.province_id = provinces.province_id
Does not work though :-(
Can anybody help please?
cheers Andy