[MyQuery]
3184 "lpattonq" "Homeroom List" "Homeroom List"
[END]
[MyQueryTables]
3184 3185 1 "EACH" "Student" no
3184 3187 2 "FIRST" "Person" no
3184 3189 3 "FIRST" "EntryWithdrawl" no
3184 3193 4 "FIRST" "EntryWithdrawlCodes" no
3184 3195 5 "FIRST" "EnrollStatus" no
3184 3198 6 "FIRST" "RoomCatalog" no
[END]
[MyQueryWhere]
3184 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 3186 "" 3185 1
3184 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 3188 "" 3187 1
3184 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2003" "" 3190 "" 3189 2
3184 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2004" "" 3191 "" 3189 3
3184 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 3192 "" 3189 1
3184 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 3194 "" 3193 1
3184 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 3196 "" 3195 2
3184 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 3197 "" 3195 1
3184 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 3199 "" 3198 1
[END]
[MyQueryFields]
3184 3205 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
3184 3206 "Person" "LastName" "" "x(15)" "Last Name" no 3
3184 3207 "Person" "FirstName" "" "x(15)" "First Name" no 2
3184 3208 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 5
3184 3220 "Student" "Gender" "" "" "Gender" no 4
[END]
[MyQuerySort]
3184 3212 "Person" "FirstName" no "" 3 "" "" no
3184 3213 "Person" "LastName" no "Count" 2 "" "" no
[END]
[MyQueryDocs]
3184 3214 2 "Portrait" 0 "" ""
3184 3215 6 "Portrait" 0 "" ""
3184 3216 1 "Portrait" 0 "" ""
3184 3217 4 "" 0 "" ""
[END]