[MyQuery]
4864 "lpattonq" "8th Grade Students Math Final Grades" "8th Grade Students Math Final Grades"
[END]
[MyQueryTables]
4864 4865 1 "EACH" "StuGrades" no
4864 4866 2 "FIRST" "SchoolCourse" no
4864 4870 3 "FIRST" "SchoolCourseDept" no
4864 4872 4 "FIRST" "Department" no
4864 4876 5 "FIRST" "Course" no
4864 4878 6 "FIRST" "GradeHeading" no
4864 4881 7 "FIRST" "Grade" no
4864 4884 8 "FIRST" "Student" no
4864 4886 9 "FIRST" "Person" no
4864 4888 10 "FIRST" "EntryWithdrawl" no
4864 4893 11 "FIRST" "EntryWithdrawlCodes" no
4864 4895 12 "FIRST" "EnrollStatus" no
[END]
[MyQueryWhere]
4864 "WHERE" "" "SchoolCourse" "SchoolCourseSeq" "=" "StuGrades" "SchoolCourseSeq" "" "" 4867 "" 4866 1
4864 "AND" "" "SchoolCourse" "CalendarYearSeq" "=" "" "" "12" "" 4868 "" 4866 2
4864 "AND" "" "SchoolCourse" "SchoolProfileSeq" "=" "" "" "1" "" 4869 "" 4866 3
4864 "Where" "" "SchoolCourseDept" "SchoolCourseSeq" "=" "StuGrades" "SchoolCourseSeq" "" "" 4871 "" 4870 1
4864 "WHERE" "" "Department" "DepartmentSeq" "=" "SchoolCourseDept" "DepartmentSeq" "" "" 4873 "" 4872 1
4864 "AND" "" "Department" "DeptDescr" "=" "" "" "Math" "" 4874 "" 4872 2
4864 "WHERE" "" "Course" "CourseSeq" "=" "SchoolCourse" "CourseSeq" "" "" 4877 "" 4876 1
4864 "AND" "" "GradeHeading" "GradeHeadingAbbr" "=" "" "" "FAvg" "" 4879 "" 4878 2
4864 "WHERE" "" "GradeHeading" "GradeHeadingSeq" "=" "StuGrades" "GradeHeadingSeq" "" "" 4880 "" 4878 1
4864 "WHERE" "" "Grade" "GradeSeq" "=" "StuGrades" "GradeSeq" "" "" 4882 "" 4881 1
4864 "WHERE" "" "Student" "StudentID" "=" "StuGrades" "StudentId" "" "" 4885 "" 4884 1
4864 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 4887 "" 4886 1
4864 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2004" "" 4889 "" 4888 3
4864 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 4890 "" 4888 1
4864 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2003" "" 4891 "" 4888 2
4864 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "SchoolCourse" "SchoolProfileSeq" "" "" 4892 "" 4888 4
4864 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 4894 "" 4893 1
4864 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 4896 "" 4895 2
4864 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 4897 "" 4895 1
4864 "AND" "" "Student" "GradeLevel" "=" "" "" "08" "" 4913 "" 4884 2
[END]
[MyQueryFields]
4864 4898 "Student" "GradeLevel" "" "X(2)" "GL" no 4
4864 4899 "Course" "CourseTitle" "" "X(15)" "Course ID" no 5
4864 4900 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
4864 4901 "Person" "LastName" "" "x(15)" "Last Name" no 2
4864 4902 "Person" "FirstName" "" "x(15)" "First Name" no 3
4864 4903 "Grade" "GradeCode" "" "X(5)" "Grade" no 7
4864 4904 "Course" "CourseDescr" "" "X(40)" "Description" no 6
[END]
[MyQuerySort]
4864 4905 "Course" "CourseTitle" yes "Count" 1 "" "" no
4864 4906 "Grade" "GradeCode" no "" 2 "" "" no
4864 4907 "Person" "FirstName" no "" 4 "" "" no
4864 4908 "Person" "LastName" no "Count" 3 "" "" no
[END]
[MyQueryDocs]
4864 4909 2 "Portrait" 0 "" ""
4864 4910 6 "Portrait" 0 "" ""
4864 4911 1 "Portrait" 0 "" ""
4864 4912 4 "" 0 "" ""
[END]