rctneil — 2010-02-11T18:58:08-05:00 — #1
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> ?
r937 — 2010-02-11T19:14:45-05:00 — #2
ON products.location_id = locations.id
WHERE locations.name = 'timbuktu'