I have two tables one for the city and the second one is for the churches.
what I want to do is to select all the cities that don't have any churches linked to.
here's my data structure.
fields: CityID, CityName, StateID, CityStatus
Fields: ChurchID, ChurchName, ChurchStatus, ChCityID
Both tables are linked my CityID and ChCityID
how can I remove all cities that do not have any church linked to?