Hi, Sorry for resending again! Need urgent help on this.
How to create the following query using DynamicViewEntity?
SELECT pcm.product_id, pp.price
FROM product_category_member pcm
INNER JOIN product_price pp ON (
pcm.product_id = pp.product_id AND price BETWEEN 15 AND 20)
WHERE pcm.product_category_id IN ('100', '101')
Thanx in advance for the help.
Regards,
Prashant
________________________________
http://www.mindtree.com/email/disclaimer.html
