Hi. I have a one-to-many relationship that I'm trying to build a query on, where I limit the number of rows returned in the collection, not in the entire result set. So for instance, where one dealership has many cars, I want a query that returns all dealerships and only 5 cars for each dealership. Can't get it to work, everything I try applies the "maxrows" to the entire result set.
Anyone have success with this or something similar?
Thanks in advance for your time and assistance...
Anyone have success with this or something similar?
Thanks in advance for your time and assistance...