Searching on a 'one to many' currently always does an outer join. This is correct when doing an 'or' query but is expensive and unnecessary when doing an 'and' query. I'd like to see if it is possible to either add some logic that determines if an outer or inner is needed or maybe add an option in the query itself.