E-learn Weblog of Willem van Valkenburg

select c.course_id "Course ID", c.course_name "Course Name",
c.available_ind "Currently Available" from course_main.c left join
activity_accumulator a on c.pk1 = a.course_pk1 where (a.event_type is
null)