Tyler,

>select course.courseid, count(studentcourse.courseid) as stdcount, >instructor.instructorid;
>from course left join studentcourse on course.courseid = >studentcourse.courseid;
>left join instructor on studentcourse.instructorid = instructor.instructorid;
>into cursor tempcourse group by course.coursei

try adding instructor.instructorid to your group by clause.

Cheers
Steve Lea