[MyQuery]
9782 "jfields" "Course Schedule 4 teachers" "Course Schedule with up to 4 teachers"
[END]
[MyQueryTables]
9782 9783 1 "EACH" "SchoolCourse" no 0
9782 9786 2 "FIRST" "Course" no 0
9782 9788 3 "EACH" "CourseSection" no 0
9782 9790 4 "FIRST" "MasterSchoolSchedule" no 0
9782 9794 5 "FIRST" "SchoolCycle" no 0
9782 9797 6 "FIRST" "SchoolPeriods" no 0
9782 9800 7 "EACH" "SchoolTerm" no 0
9782 9803 8 "FIRST" "Terms" no 0
9782 9807 9 "FIRST" "TeacherCourse" no 0
9782 9811 10 "FIRST" "Teacher" no 0
9782 9813 11 "FIRST" "bTeacherCourse" yes 0
9782 9818 12 "FIRST" "bTeacher" yes 0
9782 9833 13 "FIRST" "cTeacherCourse" yes 0
9782 9835 14 "FIRST" "cTeacher" yes 0
9782 9837 15 "FIRST" "dTeacherCourse" yes 0
9782 9839 16 "FIRST" "dTeacher" yes 0
[END]
[MyQueryWhere]
9782 "WHERE" "" "SchoolCourse" "CalendarYearSeq" "=" "" "" "25" "" 9784 "" 9783 1
9782 "AND" "" "SchoolCourse" "SchoolProfileSeq" "=" "" "" "1" "" 9785 "" 9783 2
9782 "Where" "" "Course" "CourseSeq" "=" "SchoolCourse" "CourseSeq" "" "" 9787 "" 9786 1
9782 "Where" "" "CourseSection" "SchoolCourseSeq" "=" "SchoolCourse" "SchoolCourseSeq" "" "" 9789 "" 9788 1
9782 "WHERE" "" "MasterSchoolSchedule" "CalendarYearSeq" "=" "SchoolCourse" "CalendarYearSeq" "" "" 9791 "" 9790 1
9782 "AND" "" "MasterSchoolSchedule" "SchoolCourseSeq" "=" "SchoolCourse" "SchoolCourseSeq" "" "" 9792 "" 9790 2
9782 "AND" "" "MasterSchoolSchedule" "CourseSectionSeq" "=" "CourseSection" "CourseSectionSeq" "" "" 9793 "" 9790 3
9782 "WHERE" "" "SchoolCycle" "SchoolProfileSeq" "=" "SchoolCourse" "SchoolProfileSeq" "" "" 9795 "" 9794 1
9782 "AND" "" "SchoolCycle" "SchoolCycleSeq" "=" "MasterSchoolSchedule" "SchoolCycleSeq" "" "" 9796 "" 9794 2
9782 "OUTER-JOIN WHERE" "" "cTeacherCourse" "CalendarYearSeq" "=" "SchoolCourse" "CalendarYearSeq" "" "" 9834 "" 9833 1
9782 "OUTER-JOIN WHERE" "" "cTeacher" "teacherSeq" "=" "cTeacherCourse" "teacherSeq" "" "" 9836 "" 9835 1
9782 "OUTER-JOIN WHERE" "" "dTeacherCourse" "CalendarYearSeq" "=" "SchoolCourse" "CalendarYearSeq" "" "" 9838 "" 9837 1
9782 "WHERE" "" "SchoolPeriods" "SchoolProfileSeq" "=" "SchoolCourse" "SchoolProfileSeq" "" "" 9798 "" 9797 1
9782 "AND" "" "SchoolPeriods" "SchoolPeriodsSeq" "=" "SchoolPeriods" "SchoolPeriodsSeq" "" "" 9799 "" 9797 2
9782 "WHERE" "" "SchoolTerm" "CalendarYearSeq" "=" "SchoolCourse" "CalendarYearSeq" "" "" 9801 "" 9800 1
9782 "AND" "" "SchoolTerm" "SchoolTermSeq" "=" "SchoolTerm" "SchoolTermSeq" "" "" 9802 "" 9800 2
9782 "AND" "" "Terms" "TermAbbr" "=" "" "" "Q1" "" 9804 "" 9803 3
9782 "AND" "" "Terms" "TermSeq" "=" "SchoolTerm" "TermSeq" "" "" 9805 "" 9803 2
9782 "WHERE" "" "Terms" "SchoolProfileSeq" "=" "SchoolCourse" "SchoolProfileSeq" "" "" 9806 "" 9803 1
9782 "AND" "" "TeacherCourse" "SchoolCourseSeq" "=" "SchoolCourse" "SchoolCourseSeq" "" "" 9808 "" 9807 2
9782 "WHERE" "" "TeacherCourse" "CalendarYearSeq" "=" "SchoolCourse" "CalendarYearSeq" "" "" 9809 "" 9807 1
9782 "AND" "" "TeacherCourse" "CourseSectionSeq" "=" "CourseSection" "CourseSectionSeq" "" "" 9810 "" 9807 3
9782 "AND" "" "cTeacherCourse" "SchoolCourseSeq" "=" "SchoolCourse" "SchoolCourseSeq" "" "" 9841 "" 9833 2
9782 "AND" "" "cTeacherCourse" "CourseSectionSeq" "=" "CourseSection" "CourseSectionSeq" "" "" 9842 "" 9833 3
9782 "AND" "" "cTeacherCourse" "teacherSeq" "<>" "TeacherCourse" "teacherSeq" "" "" 9843 "" 9833 4
9782 "Where" "" "Teacher" "teacherSeq" "=" "TeacherCourse" "teacherSeq" "" "" 9812 "" 9811 1
9782 "OUTER-JOIN WHERE" "" "dTeacher" "teacherSeq" "=" "dTeacherCourse" "teacherSeq" "" "" 9840 "" 9839 1
9782 "AND" "" "bTeacherCourse" "CourseSectionSeq" "=" "CourseSection" "CourseSectionSeq" "" "" 9814 "" 9813 4
9782 "OUTER-JOIN WHERE" "" "bTeacherCourse" "CalendarYearSeq" "=" "SchoolCourse" "CalendarYearSeq" "" "" 9815 "" 9813 1
9782 "AND" "" "bTeacherCourse" "SchoolCourseSeq" "=" "SchoolCourse" "SchoolCourseSeq" "" "" 9816 "" 9813 2
9782 "AND" "" "bTeacherCourse" "teacherSeq" "<>" "TeacherCourse" "teacherSeq" "" "" 9817 "" 9813 3
9782 "OUTER-JOIN WHERE" "" "bTeacher" "teacherSeq" "=" "bTeacherCourse" "teacherSeq" "" "" 9819 "" 9818 1
9782 "AND" "" "cTeacherCourse" "teacherSeq" "<>" "bTeacherCourse" "teacherSeq" "" "" 9844 "" 9833 5
9782 "AND" "" "dTeacherCourse" "SchoolCourseSeq" "=" "SchoolCourse" "SchoolCourseSeq" "" "" 9845 "" 9837 2
9782 "AND" "" "dTeacherCourse" "CourseSectionSeq" "=" "CourseSection" "CourseSectionSeq" "" "" 9846 "" 9837 3
9782 "AND" "" "dTeacherCourse" "teacherSeq" "<>" "TeacherCourse" "teacherSeq" "" "" 9847 "" 9837 4
9782 "AND" "" "dTeacherCourse" "teacherSeq" "<>" "bTeacherCourse" "teacherSeq" "" "" 9848 "" 9837 5
9782 "AND" "" "dTeacherCourse" "teacherSeq" "<>" "cTeacherCourse" "teacherSeq" "" "" 9849 "" 9837 6
[END]
[MyQueryFields]
9782 9820 "Teacher" "PrintName" "" "X(20)" "Teacher" no 7 0
9782 9821 "SchoolPeriods" "PeriodTitleAbbr" "" "X(2)" "Period" no 6 0
9782 9822 "SchoolCycle" "DayTitleAbbr" "" "X(2)" "Day" no 5 0
9782 9823 "Course" "CourseName" "" "X(10)" "Name" no 2 0
9782 9824 "CourseSection" "CourseSecDesc" "" "x(2)" "Course Sec" no 3 0
9782 9825 "Course" "CourseTitle" "" "X(15)" "Title" no 1 0
9782 9826 "bTeacher" "PrintName" "" "X(20)" "2nd Teacher" no 8 0
9782 9827 "Terms" "TermAbbr" "" "X(2)" "Term" no 4 0
9782 9850 "cTeacher" "PrintName" "" "X(20)" "3rd Teacher" no 9 0
9782 9851 "dTeacher" "PrintName" "" "X(20)" "4th Teacher" no 10 0
[END]
[MyQuerySort]
9782 9832 "Course" "CourseName" no "" 1 "" "" no
[END]
[MyQueryDocs]
9782 9828 1 "Portrait" 0 "" ""
9782 9829 4 "" 0 "" ""
9782 9830 2 "" 0 "" ""
9782 9831 6 "" 0 "" ""
[END]