[MyQuery]
311 "npsimg9408" "Course MSB BY Teacher Room [2]" "Copy Of Course MSB BY Teacher Room"
[END]
[MyQueryTables]
311 312 1 "EACH" "SchoolCourse" no
311 315 2 "FIRST" "Course" no
311 317 3 "EACH" "CourseSection" no
311 319 4 "FIRST" "MSBRoomTeacher" no
311 321 5 "FIRST" "Teacher" no
311 323 6 "FIRST" "Person" no
311 325 7 "FIRST" "RoomCatalog" no
[END]
[MyQueryWhere]
311 "WHERE" "" "SchoolCourse" "SchoolProfileSeq" "=" "" "" "1" "" 313 "" 312 1
311 "AND" "" "SchoolCourse" "CalendarYearSeq" "=" "" "" "10" "" 314 "" 312 2
311 "Where" "" "Course" "CourseSeq" "=" "SchoolCourse" "CourseSeq" "" "" 316 "" 315 1
311 "Where" "" "CourseSection" "SchoolCourseSeq" "=" "SchoolCourse" "SchoolCourseSeq" "" "" 318 "" 317 1
311 "OUTER-JOIN WHERE" "" "MSBRoomTeacher" "CourseSectionSeq" "=" "CourseSection" "CourseSectionSeq" "" "" 320 "" 319 1
311 "OUTER-JOIN WHERE" "" "Teacher" "teacherSeq" "=" "MSBRoomTeacher" "teacherSeq" "" "" 322 "" 321 1
311 "OUTER-JOIN WHERE" "" "Person" "PersonSeq" "=" "Teacher" "PersonSeq" "" "" 324 "" 323 1
311 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "MSBRoomTeacher" "RoomCatalogSeq" "" "" 326 "" 325 1
[END]
[MyQueryFields]
311 327 "Person" "LastName" "" "x(15)" "Last Name" no 1
311 328 "RoomCatalog" "RoomCode" "" "X(8)" "Room" no 2
311 329 "Course" "CourseTitle" "" "X(15)" "ID" no 3
311 330 "CourseSection" "CourseSecDesc" "" "x(2)" "Course Sec" no 4
[END]
[MyQuerySort]
311 331 "Course" "CourseTitle" no "" 3 "" "" no
311 332 "CourseSection" "CourseSecDesc" no "" 4 "" "" no
311 333 "Person" "LastName" no "" 1 "" "" no
311 334 "RoomCatalog" "RoomCode" no "" 2 "" "" no
[END]
[MyQueryDocs]
311 335 2 "Portrait" 0 "" ""
311 336 6 "Portrait" 0 "" ""
311 337 1 "Portrait" 0 "" ""
311 338 4 "" 0 "" ""
[END]