Chris,

Maybe you're right.

If I subquery (select from select) the dataset with valid relationships, everything's fine. If I drop the subquery and depend on the criteria to limit the returned data, it errors saying that there is a relationship integrity problem (2 parents for 1 child).

It doesn't make any sense to check for relationship integrity across the entire table first.