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]