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
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 someth