Bit of MySQL help needed with JOINS

[Django x2]

Hi all, I've peaked here with SELECT * FROM PRODUCTS as that is about as far as I seem to be able to go with SQL so hoping someone can help

Simply, we have 4 tables:

Products (which uses integers to reference data in other tables - this is the daddy table)
Type (the type of product with an ID and Value field)
Manufacturer (the manuf of the product with an ID and Value field)
Model (the model of the product with an ID and Value field)

Say that in Type you had
1, Car
2, Bus
3, Lorry

In Manufacturer you had
1, Volvo
2, Ford
3, Scania

and in Model you had
1, XC90
2, V70
3, FH16
4, R-Series

in Products would be
1, 1, 1 (which would relate to Car, Volvo, XC90)
3, 1, 3 (which would be Lorry, Volvo, FH16)
3, 3, 4 (which would be Lorry, Scania, R Series)

How can I get the JOIN query to give me that result instead of the integer?

Thanks

 

[Django x2]

Thanks Touch, I actually managed to work it out just as you posted. Thanks all the same

SELECT t.Value, ma.Value, mo.Value FROM Products p
JOIN Type t ON p.TypeId = t.Id
JOIN Manufacturer ma ON p.ManufacturerId = m.Id
JOIN Model mo ON p.ModelId = mo.Id

 

[Django x2]

Cool, that makes sense. Thanks