Hi Jim,

>That is not true, your where is evaluating the field for .T. and NULL is NOT .T. it is NULL so those records are removed from the result because they don't meet your where clause even though they were part of the left outer join.

The question was why are the records NOT removed. The first example has a left outer join and an where clause checking for lProperty = .T. I would expect to get a resultset with lProperty = .T. and no NULL's. That's not what we found. We got a result set with .T. and with NULL's for for records from table1 without matching records in table2.