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 (http://www.php.net/)
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