select c.*, sc.* 
from category c, subcategory sc
where c.categoryID = sc.categoryID
and categoryID = <the category you want>