[MyQuery]
5985 "lpattonq" "4 years of Math Courses" "4 years of Math Courses"
[END]
[MyQueryTables]
5985 5986 1 "EACH" "Student" no
5985 5988 2 "EACH" "StuRequest" no
5985 5991 3 "FIRST" "SchoolCourse" no
5985 5995 4 "FIRST" "StuTermCourse" no
5985 5998 5 "FIRST" "Course" no
5985 6000 6 "FIRST" "SchoolCourseDept" no
5985 6002 7 "FIRST" "Department" no
5985 6024 8 "FIRST" "Person" no
5985 6026 9 "FIRST" "RoomCatalog" no
5985 6042 10 "FIRST" "CalendarYear" no
[END]
[MyQueryWhere]
5985 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 5987 "" 5986 1
5985 "WHERE" "" "StuRequest" "StudentID" "=" "Student" "StudentID" "" "" 5989 "" 5988 1
5985 "AND" "" "SchoolCourse" "SchoolProfileSeq" "=" "" "" "1" "" 5992 "" 5991 2
5985 "WHERE" "" "SchoolCourse" "SchoolCourseSeq" "=" "StuRequest" "SchoolCourseSeq" "" "" 5994 "" 5991 1
5985 "WHERE" "" "StuTermCourse" "StudentID" "=" "Student" "StudentID" "" "" 5996 "" 5995 1
5985 "AND" "" "StuTermCourse" "SchoolCourseSeq" "=" "StuRequest" "SchoolCourseSeq" "" "" 5997 "" 5995 2
5985 "WHERE" "" "Course" "CourseSeq" "=" "SchoolCourse" "CourseSeq" "" "" 5999 "" 5998 1
5985 "Where" "" "SchoolCourseDept" "SchoolCourseSeq" "=" "StuRequest" "SchoolCourseSeq" "" "" 6001 "" 6000 1
5985 "AND" "" "Department" "DeptDescr" "=" "" "" "Math" "" 6003 "" 6002 2
5985 "WHERE" "" "Department" "DepartmentSeq" "=" "SchoolCourseDept" "DepartmentSeq" "" "" 6004 "" 6002 1
5985 "Where" "" "CalendarYear" "CalendarYearSeq" "=" "StuRequest" "CalendarYearSeq" "" "" 6043 "" 6042 1
5985 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 6025 "" 6024 1
5985 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 6027 "" 6026 1
[END]
[MyQueryFields]
5985 6044 "CalendarYear" "AcademicYear" "" "9999-9999" "Academic!Year" no 6
5985 6028 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
5985 6029 "Person" "LastName" "" "x(15)" "Last Name" no 2
5985 6030 "Person" "FirstName" "" "x(15)" "First Name" no 3
5985 6031 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 5
5985 6032 "Student" "GradeLevel" "" "X(2)" "GL" no 4
5985 6033 "Course" "CourseTitle" "" "X(15)" "Course ID" no 7
5985 6034 "Department" "DeptDescr" "" "X(30)" "Department " no 8
[END]
[MyQuerySort]
5985 6045 "CalendarYear" "AcademicYear" no "" 3 "" "" no
5985 6036 "Person" "FirstName" no "" 2 "" "" no
5985 6037 "Person" "LastName" no "Count" 1 "" "" no
[END]
[MyQueryDocs]
5985 6038 2 "Portrait" 0 "" ""
5985 6039 6 "Portrait" 0 "" ""
5985 6040 1 "Portrait" 0 "" ""
5985 6041 4 "" 0 "" ""
[END]