>OK, if insist
>Maybe I am missing something, but I don't see any reason for second select, why not just:
>

>select * from Visits;
>    INTO CURSOR test
>BROW
>

>
>Or if you want to join doctors table (if you select some fields from Doctors table), use LEFT join not INNER.
>

>select *, Doctros.SomeField;
>    FROM Visits;
>    LEFT JOIN Doctors ON Visits.DoctorField = Doctors.MatchingField
>    INTO CURSOR test
>BROW
>

>
>
Would not work.