Re: How to write this querry?
| From: | Bas Jobsen | Date: | Sun, 30 Dec 2001 21:05:07 +0000 |
| Subject: | Re: How to write this querry? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15276@lists.php.net to get a copy of this message | ||
delete from cities
where cities.province_id<>provinces.province_id
Op zondag 30 december 2001 21:55, schreef Andy:
> 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