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

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to