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> ?
ON products.location_id = locations.id
WHERE locations.name = 'timbuktu'