Hi,
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,
Asit Patadia| Module Lead| MindTree Ltd. Maruthi Chambers, No. 17/9C, 17/4C,
Rupena Agrahara, Hosur Road, Bangalore - 560 068, INDIA |
Voice +91 80 25738005 x 6088 / Fax +91 80 41100587 | email:
[email protected]<mailto:[email protected]>
|www.mindtree.com<blocked::http://www.mindtree.com/> |
________________________________
http://www.mindtree.com/email/disclaimer.html
