>I was told by some people (including support at Microsoft) that doing a Left
>Outer join and filtering on the child table is not a logical thing to do.

Please tell me it wasn't me you talked to -- I seem to recall using that phrase on someone...