Hi All,
Can we write a sub query using entity engine ?
Here is the query which is to be generated using entity engine.
Thanks in advance.
Regards,
Prashant
SELECT
pc.category_name
,COUNT(DISTINCT p.product_id)
FROM product_category_member pcm INNER JOIN
product_category pc
ON pc.product_category_id = pcm.product_category_id LEFT OUTER JOIN
(
SELECT p.product_id
FROM product p INNER JOIN
inventory_item ii
ON p.product_id = ii.product_id
GROUP BY p.product_id
HAVING SUM(ii.AVAILABLE_TO_PROMISE_TOTAL) > 0 /***no inventory**/) AS p
ON pcm.product_id = p.product_id
GROUP BY pc.category_name
________________________________
http://www.mindtree.com/email/disclaimer.html
