[MyQuery]
7784 "lpattonq" "Earned Credits" "Earned Credits"
[END]
[MyQueryTables]
7784 7785 1 "EACH" "Student" no
7784 7820 2 "FIRST" "StuCredits" no
7784 7787 3 "FIRST" "Person" no
7784 7789 4 "FIRST" "EntryWithdrawl" no
7784 7793 5 "FIRST" "EntryWithdrawlCodes" no
7784 7795 6 "FIRST" "EnrollStatus" no
7784 7798 7 "FIRST" "RoomCatalog" no
[END]
[MyQueryWhere]
7784 "WHERE" "" "StuCredits" "StudentID" "=" "Student" "StudentID" "" "" 7821 "" 7820 1
7784 "AND" "" "StuCredits" "CalendarYearSeq" "=" "" "" "1" "" 7822 "" 7820 2
7784 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2003" "" 7790 "" 7789 2
7784 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2004" "" 7791 "" 7789 3
7784 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 7792 "" 7789 1
7784 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 7794 "" 7793 1
7784 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 7796 "" 7795 2
7784 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 7797 "" 7795 1
7784 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 7799 "" 7798 1
7784 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 7786 "" 7785 1
7784 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 7788 "" 7787 1
[END]
[MyQueryFields]
7784 7823 "StuCredits" "EarnedCredit" "" "->>,>>9.999" "EarnedCredit" no 5
7784 7807 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
7784 7808 "Person" "LastName" "" "x(15)" "Last Name" no 2
7784 7809 "Person" "FirstName" "" "x(15)" "First Name" no 3
7784 7811 "Student" "GradeLevel" "" "X(2)" "GL" no 4
[END]
[MyQuerySort]
7784 7814 "Person" "FirstName" no "" 3 "" "" no
7784 7815 "Person" "LastName" no "Count" 2 "" "" no
[END]
[MyQueryDocs]
7784 7816 2 "Portrait" 0 "" ""
7784 7817 6 "Portrait" 0 "" ""
7784 7818 1 "Portrait" 0 "" ""
7784 7819 4 "" 0 "" ""
[END]