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:
LodgeID (Foreign Key to tbl_Lodges)
CountryID (Foreign Key to t/l_Countries)
So that for any given LodgeID I can display:
Lodge, Nomination and Country?