>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. However, no one provided another alternative to get the data that I wanted.

What data were you trying to get? As Michel learned, when you filter the child after an outer join, the records added by the outer join fall out.

Tamar