SELECT p.*,
m.name AS manufacturer
FROM product p
INNER JOIN product_to_category ptc
ON p.product_id = ptc.product_id
INNER JOIN manufacturer m
ON p.manufacturer_id = m.manufacturer_id
INNER JOIN product_status ps
ON p.product_status_id = ps.product_status_id WHERE ps.code = 'A' AND ptc.category_id = 280 ORDER BY m.name
Heinman Machinery Ltd. - -
905-564-9479