Performing complex query with Dynamics CRM 4.0
- by dub
Hi,
I have two custom entites, Product and ProductType, linked together in many-to-one relationship. Product has a lookup field to ProductType.
I'm trying to write a query to fetch Type1 products with a price over 100, and Type2 products with a price lower than 100.
Here's how I would do it in SQL :
select *
from Product P
inner join…