Join Query

Databases
1

Hey,
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> ?

2 
SELECT products.name
  FROM locations
INNER
  JOIN products
    ON products.location_id = locations.id
 WHERE locations.name = 'timbuktu'