Course Schedule

SELECT sce_public.*, sce_schedule.id as ScheduledId, sce_schedule.date as ScheduledDate, sce_schedule.location as ScheduledLocation from sce_public inner join sce_schedule on sce_public.id = sce_schedule.course_id where date > NOW() AND sce_public.obsolete <> 1 ORDER BY ScheduledDate ASC