How to write Join Query for 3 tables

[kamal11]

i have 3 tables:- sector, category, subategory

sector table
id->primary key
sector-name

category table
id->primary key
secid->Foreign key to sector table
category-name

subcategory
id->primary key
secid->Foreign key to sector table
catid->Foreign key to category table
subcat-name

now i want sector-name, category-name and subcat-name from 3 tables..how to join these 3 tables....

[sunfighter]

SELECT s.sector-name, c.category-name, sub.subcat-name
FROM `sector table` s, `category table` c, `subcategory` sub
WHERE s.id = c.secid
AND c.secid = sub.secid