SQL Query syntax - joins

Databases
1

Hopefully this is a quick one.

I’m OK with standard inner joins linking a couple of tables, but what would the syntax be to query three takes like this:

tbl_Nominations
NominationID (PK)
Nomination
LodgeID (Foreign Key to tbl_Lodges)

tbl_Lodges
LodgeID (PK)
Lodge
CountryID (Foreign Key to t/l_Countries)

tbl_Countries
CountryID
Country

So that for any given LodgeID I can display:

Lodge, Nomination and Country?

Thanks.

2

what have you tried?

3

I was trying outer joins, but think I might have it now, with:

SELECT * FROM nominations LEFT OUTER JOIN lodges ON nominations.LodgeID = lodges.LodgeID LEFT OUTER JOIN continents ON lodges.ContinentID = continents.ContinentID

Does that sound about right? (Where Nominations was the starting table, not Lodges)

4

unless you have a nomination in a lodge that doesn’t exist, or a lodge in a country/continent that doesn’t exist, use inner joins