Help with some SQL

[MrBaseball34]

I'm developing some code to create a file for another process of ours and was wondering if anyone could help out on this SQL.

SELECT ps_product_lang.description_short AS description, 
      ps_product.id_product AS prod_id, 
      ps_product.quantity AS quantity, 
      ps_product.price AS price,
      ps_product.wholesale_price AS wholesale_price,
      ps_manufacturer.name AS manufacturer,
      ps_category_lang.name as category,
      ps_supplier.name as supplier
FROM ps_product 
LEFT JOIN ps_product_lang ON ps_product_lang.id_product = ps_product.id_product 
 AND ps_product_lang.id_lang = 1 -- use lang variable here
LEFT JOIN ps_manufacturer ON ps_manufacturer.id_manufacturer  = ps_product.id_manufacturer
LEFT JOIN ps_category_product ON ps_category_product.id_product = ps_product.id_product
LEFT JOIN ps_category_lang ON ps_category_lang.id_category = ps_category_product.id_category 
 AND ps_category_lang.id_lang = 1 -- use lang variable here
LEFT JOIN ps_supplier ON ps_supplier.id_supplier = ps_product.id_supplier
ORDER BY ps_product.id_product

I need to know how to work in the sub-categories.

[tomerg3]

Need more information....

What exactly are you trying to do and what subcategories are you trying to get?

[MrBaseball34]

Isn't it obvious from the SQL what I'm trying to do? I need the subcategory for the product. I already have the category but not sure how to get the subcategory.

[MrBaseball34]

Anyone else???

[MrBaseball34]

Can anyone help out here?