I have an entity, Location, which has List. While querying Location, I only want the areas which have a STATUS field of 0 (zero). Is it possible to do this in one query or do I need to do it the "hard way?"
BTW, this is an outer join, where some Locations will not have Areas associated with them at all.