I seem to remember it works when all the tables in the SQL were already open before executing the SQL. I have not experimented with the *why* success is intermittent. I just know that it will be a cold day in August in Dallas before I use a nested join.

>Thanks. That has solved the problem, but do you have any idea why the nested joins would work sometimes and not others?
>
>
>>Start by un-nesting the JOINs.

>>
>>SELECT Subjects.subjcode, Subjects.subjname, Attendnc.passed,;
>>     Attendnc.att_part,Attendnc.absent, Attendnc.rpl,;
>>     Attendnc.concldate, SPACE(60) AS lect_name, Attendnc.withdrawn,;
>>     Attendnc.completed, Subjects.subject_id, Attendnc.enrol_id,;
>>     Enrolmts.su_stdate, Attendnc.memb_num, Attendnc.lect_num;
>>     FROM attendnc ;
>>        INNER JOIN subjects ;
>>          ON Attendnc.subject_id=Subjects.subject_id;
>>        INNER JOIN enrolmts;
>>          ON Attendnc.enrol_id=Enrolmts.enrol_id;
>>     WHERE Attendnc.course_id=CF.course_id .AND.;
>>           Attendnc.memb_num=Stu2.memb_num .AND.;
>>           ATTENDNC.ENROL_ID=CF.ENROL_ID .AND. &ATT_COND.;
>>     ORDER BY Subjects.subjcode, Subjects.subject_id ;
>>     INTO CURSOR ATTTMP