select o.title, sc.online, sc.default_lesson_mode from scorm_courses sc, acs_objects o where sc.scorm_course_id = :id and o.object_id = sc.scorm_course_id update scorm_courses set online = :online, default_lesson_mode = :default_lesson_mode where scorm_course_id = :id