...
| Code Block |
|---|
select 1 from v_external_student_transcript_course
where school_id = :plan_student_id
and formatted_course = :planned_formatted_course
and term_code = :planned_term_code |
Forward-looking:
| Code Block |
|---|
select 1 from v_external_student_transcript_course where school_id = :plan_student_id and formatted_course = :planned_formatted_course and term_code in (select term_code from external_course_term where course_code = :planned_formatted_course) |
...