[MyQuery]
14917 "wpsimg9408" "On-line_Recommendations_Detailed_iParent_New" "On-line Recommendations Detailed iParent New"
[END]
[MyQueryTables]
14917 14918 1 "EACH" "StuPriSchoolYear" no 0
14917 14921 2 "EACH" "GuardianStudent" no 0
14917 14923 3 "FIRST" "Person" no 0
14917 14925 4 "FIRST" "Users" no 0
14917 14927 5 "EACH" "StuRecRequest" no 0
14917 14930 6 "FIRST" "SchoolCourse" no 0
14917 14934 7 "FIRST" "Course" no 0
14917 14936 8 "FIRST" "Student" no 0
14917 14938 9 "FIRST" "bPerson" yes 0
14917 14940 10 "EACH" "StuRecReqUsersX" no 0
[END]
[MyQueryWhere]
14917 "OUTER-JOIN WHERE" "" "Course" "CourseSeq" "=" "SchoolCourse" "CourseSeq" "" "" 14935 "" 14934 1
14917 "WHERE" "" "Student" "StudentID" "=" "StuRecRequest" "StudentID" "" "" 14937 "" 14936 1
14917 "WHERE" "" "StuPriSchoolYear" "CalendarYearSeq" "=" "" "" "17" "" 14919 "" 14918 1
14917 "AND" "" "StuPriSchoolYear" "SchoolProfileSeq" "=" "" "" "1" "" 14920 "" 14918 2
14917 "WHERE" "" "GuardianStudent" "studentId" "=" "StuPriSchoolYear" "StudentID" "" "" 14922 "" 14921 1
14917 "Where" "" "Person" "PersonSeq" "=" "GuardianStudent" "PersonSeq" "" "" 14924 "" 14923 1
14917 "WHERE" "" "bPerson" "PersonSeq" "=" "Student" "personSeq" "" "" 14939 "" 14938 1
14917 "WHERE" "" "StuRecReqUsersX" "UsersID" "=" "Users" "UsersID" "" "" 14941 "" 14940 1
14917 "Where" "" "Users" "PersonSeq" "=" "GuardianStudent" "PersonSeq" "" "" 14926 "" 14925 1
14917 "WHERE" "" "StuRecRequest" "StudentID" "=" "StuPriSchoolYear" "StudentID" "" "" 14928 "" 14927 1
14917 "AND" "" "StuRecRequest" "CalendarYearSeq" "=" "StuPriSchoolYear" "CalendarYearSeq" "" "" 14929 "" 14927 2
14917 "OUTER-JOIN WHERE" "" "SchoolCourse" "SchoolCourseSeq" "=" "StuRecRequest" "SchoolCourseSeq" "" "" 14931 "" 14930 1
14917 "AND" "" "SchoolCourse" "CalendarYearSeq" "=" "StuRecRequest" "CalendarYearSeq" "" "" 14932 "" 14930 2
14917 "AND" "" "SchoolCourse" "SchoolProfileSeq" "=" "StuPriSchoolYear" "SchoolProfileSeq" "" "" 14933 "" 14930 3
14917 "AND" "" "StuRecReqUsersX" "StuRecRequestSeq" "=" "StuRecRequest" "StuRecRequestSeq" "" "" 14943 "" 14940 2
[END]
[MyQueryFields]
14917 14944 "Course" "CourseTitle" "" "X(15)" "Course Title" no 8 0
14917 14945 "Person" "LastName" "" "x(15)" "Parent Last Name" no 1 0
14917 14946 "Person" "FirstName" "" "x(15)" "Parent First Name" no 2 0
14917 14947 "StuRecRequest" "studentId" "" ">>>>>9" "Student ID" no 3 0
14917 14948 "StuRecRequest" "CreateDate" "" "99/99/9999" "Create Date" no 7 0
14917 14949 "Course" "CourseName" "" "X(10)" "Course Name" no 9 0
14917 14950 "bPerson" "LastName" "" "x(15)" "Student Last Name" no 4 0
14917 14951 "bPerson" "FirstName" "" "x(15)" "Student First Name" no 5 0
14917 14952 "StuRecReqUsersX" "Comment" "" "x(50)" "Comment" no 10 0
14917 14953 "Student" "GradeLevel" "" "X(2)" "Student Grade Level" no 6 0
[END]
[MyQuerySort]
14917 14954 "bPerson" "FirstName" no "" 4 "" "" no
14917 14955 "bPerson" "LastName" no "" 3 "" "" no
14917 14956 "Person" "FirstName" no "" 2 "" "" no
14917 14957 "Person" "LastName" no "" 1 "" "" no
14917 14958 "StuRecRequest" "StuRecRequestSeq" no "" 5 "" "" no
14917 14959 "Users" "UsersID" yes "Count" 6 "" "" no
[END]
[MyQueryDocs]
14917 14960 2 "Portrait" 0 "" ""
14917 14961 6 "Portrait" 0 "" ""
14917 14962 1 "Portrait" 0 "" ""
14917 14963 4 "" 0 "" ""
[END]