4 tables query 1

[w11z]

Hi, I have 4 tables
Table 1: institutions
instID
instName
CityID (FK)

Table 2: cities
cityID
cityName
regionID (FK)
countryID (FK)

Table 3: regions
regionID
regionName
countryID (FK)

Table 4: countries
countryID
countryName

I'm trying to list all the institution name, the city, the region and the country it belongs to. I've tried several ways but never arrive at anything good. Can someone help me?

 

[r937]

SELECT institutions.instName
     , cities.cityName
     , regions.regionName
     , countries.countryName
  FROM institutions
INNER
  JOIN cities
    ON cities.cityID = institutions.instID
INNER
  JOIN regions
    ON regions.regionID = cities.regionID
INNER
  JOIN countries
    ON countries.countryID = regions.countryID

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[w11z]

Thank you r937. It worked perfectly.