Works fine for me in VFP8. Though I always do Parent.pk = Child.fk in the JOIN condition and not reversed as you did. Don't think it's the problem here.

>Hi All -- I tried creating a CursorAdapter class with a SQL statement similar to:
>
>SELECT t1.*, t2.* FROM t1 LEFT OUTER JOIN t2 on t2.t1_fk = t1.pk
>
>When I run the CursorFill() method on an instance of the class, I get nothing. When I change the SQL to:
>
>SELECT t1.*, t2.* FROM t1, t2 WHERE t2.t1_fk = t1.pk
>
>From this SQL statement I get results. SET ENGINEBEHAVIOR is 90 (tried in 70, 80 and 90), so I am fairly sure it is not that. However, I am at a loss and wondering if any of you might know what's wrong.
>
>Thanks in advance,
>Larry Rix