Hi I'm creating the following basic tables
COUNTRIES countries_id name REGIONS region_id countries_id name CITIES cities_id region_id Using joins I can obtain which country each city belongs too. However, should I consider putting a foreign key in the CITIES table referencing the countries_id ? Or is it sufficient to access using a join ? Thanks Neil
