[MyQuery]
617 "cpsimg9408" "On-line_Recommendations_Detailed_iTeacher" "On-line_Recommendations_Detailed_iTeacher"
[END]
[MyQueryTables]
617 618 1 "EACH" "Teacher" no 0
617 619 2 "FIRST" "Person" no 0
617 621 3 "FIRST" "Users" no 0
617 623 4 "EACH" "StuRecRequest" no 0
617 625 5 "FIRST" "SchoolCourse" no 0
617 629 6 "FIRST" "Course" no 0
617 631 7 "FIRST" "Student" no 0
617 633 8 "FIRST" "bTeacher" yes 0
617 635 9 "FIRST" "bPerson" yes 0
617 637 10 "FIRST" "gradeLevel" no 0
[END]
[MyQueryWhere]
617 "WHERE" "" "Users" "PersonSeq" "=" "Person" "PersonSeq" "" "" 622 "" 621 1
617 "WHERE" "" "SchoolCourse" "SchoolCourseSeq" "=" "StuRecRequest" "SchoolCourseSeq" "" "" 626 "" 625 1
617 "WHERE" "" "Person" "PersonSeq" "=" "Teacher" "PersonSeq" "" "" 620 "" 619 1
617 "AND" "" "SchoolCourse" "SchoolProfileSeq" "=" "" "" "1" "" 627 "" 625 2
617 "AND" "" "SchoolCourse" "CalendarYearSeq" "=" "" "" "17" "" 628 "" 625 3
617 "Where" "" "gradeLevel" "GradeLevel" "=" "Student" "GradeLevel" "" "" 638 "" 637 1
617 "WHERE" "" "bTeacher" "teacherSeq" "=" "Student" "Counselor" "" "" 634 "" 633 1
617 "WHERE" "" "bPerson" "PersonSeq" "=" "Student" "personSeq" "" "" 636 "" 635 1
617 "WHERE" "" "StuRecRequest" "createUser" "=" "Users" "UsersID" "" "" 624 "" 623 1
617 "Where" "" "Course" "CourseSeq" "=" "SchoolCourse" "CourseSeq" "" "" 630 "" 629 1
617 "WHERE" "" "Student" "StudentID" "=" "StuRecRequest" "StudentID" "" "" 632 "" 631 1
[END]
[MyQueryFields]
617 645 "bPerson" "LastName" "" "x(15)" "Student Last Name" no 4 0
617 646 "bPerson" "FirstName" "" "x(15)" "Student First Name" no 5 0
617 647 "gradeLevel" "GradeLevel" "" "X(2)" "Grade Level" no 6 0
617 648 "bTeacher" "PrintName" "" "X(20)" "Counselor" no 7 0
617 639 "Course" "CourseTitle" "" "X(15)" "Course ID" no 8 0
617 640 "Person" "LastName" "" "x(15)" "Teacher Last Name" no 1 0
617 641 "Person" "FirstName" "" "x(15)" "Teacher First Name" no 2 0
617 642 "StuRecRequest" "studentId" "" ">>>>>9" "Student ID" no 3 0
617 643 "StuRecRequest" "CreateDate" "" "99/99/9999" "Create Date" no 10 0
617 644 "Course" "CourseName" "" "X(10)" "Course Name" no 9 0
[END]
[MyQuerySort]
617 649 "bPerson" "FirstName" no "" 5 "" "" no
617 650 "bPerson" "LastName" no "" 4 "" "" no
617 651 "Course" "CourseTitle" no "" 3 "" "" no
617 652 "Person" "FirstName" no "" 2 "" "" no
617 653 "Person" "LastName" yes "Count" 1 "" "" no
[END]
[MyQueryDocs]
617 654 2 "Portrait" 0 "" ""
617 655 6 "Portrait" 0 "" ""
617 656 1 "Portrait" 0 "" ""
617 657 4 "" 0 "" ""
[END]