>from studentcourse left join instructor on studentcourse.instructorid = instructor.instructorid,;
>courseprogram left join program on courseprogram.programid = program.programid;
>where courseprogram.courseid = studentcourse.courseid;

Here you are making two of your joins using ANSI SQL-92 JOIN syntax, and one using the old-fashioned WHERE join syntax. That is not wrong, but may be confusing, and may be related to any incorrect results you are seeing. I, for one, get easily confused when trying to join three tables, and like to use strict JOIN syntax, without nested joins.