Correct SQL Statement for Joining Taxonomy Terms
If you want to show Locations a Course is offered. Or Courses at a Location I would recommend using the Views Field module, or perhaps Context to show a View on the content type page.

Views field allows you send parameters to the embedded field view from the source Node. So you should be able to get the related content(s) you want to show by passing the necessary filter parameter criteria you want to the View -- usually as a contextual filter.

For example for a Landing Page Content Type (eg, First Aid) you add a field that is a View. Call the view like locations for course. Then make a View that outputs Location taxonomy term names based on a contextual filters. The contextual filter will be:


the taxonomy term name of the course(s) in your taxonomy of Courses.


Then output the taxonomy Location term names for results of the set course name contextual filter. Overwrite the linkpath as needed.