Selecting fields from multiple tables

Hi,

If you have a few tables.

table 1 - products: [Code, prodCode, supplierNumber]
table 2 - suppliers: [code, name]
table 3 - types: [code, name]

How do you select a few fields from the let's say 3 tables, where products.typeCode = types.code, products.supplierCode = suppliers.code .........

Thanks

select products.code, products.prodcode, products.suppliernumber, suppliers.name as suppliername, types.name as typesname
from products
LEFT JOIN suppliers AS suppliers ON(suppliers.code = products.code)
LEFT JOIN types AS types ON(types.code = products.code)