If I have two tables one called products and one called locations. One product can be in one location but each location can have many products. Each product record has a location id pointing to a location in the location table.

How can I use a join query to say select product.name where location = <nameoflocation> ?