[MyQuery]
4050 "lpattonq" "Bus List" "Bus List"
[END]
[MyQueryTables]
4050 4051 1 "EACH" "Student" no
4050 4053 2 "FIRST" "Person" no
4050 4055 3 "FIRST" "EntryWithdrawl" no
4050 4059 4 "FIRST" "EntryWithdrawlCodes" no
4050 4061 5 "FIRST" "EnrollStatus" no
4050 4064 6 "FIRST" "RoomCatalog" no
4050 4084 7 "EACH" "StuBus" no
4050 4492 8 "FIRST" "busRouteBusX" no
4050 4494 9 "FIRST" "Bus" no
4050 4111 10 "FIRST" "addressPerson" no
4050 4093 11 "EACH" "Address" no
[END]
[MyQueryWhere]
4050 "AND" "" "StuBus" "DayOfWeek" "=" "" "" "2" "" 4498 "" 4084 3
4050 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 4052 "" 4051 1
4050 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 4054 "" 4053 1
4050 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2003" "" 4056 "" 4055 2
4050 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2004" "" 4057 "" 4055 3
4050 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 4058 "" 4055 1
4050 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 4060 "" 4059 1
4050 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 4062 "" 4061 2
4050 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 4063 "" 4061 1
4050 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 4065 "" 4064 1
4050 "OUTER-JOIN WHERE" "" "StuBus" "StudentID" "=" "Student" "StudentID" "" "" 4085 "" 4084 1
4050 "WHERE" "" "addressPerson" "studentId" "=" "EntryWithdrawl" "StudentID" "" "" 4112 "" 4111 1
4050 "WHERE" "" "Address" "AddressSeq" "=" "addressPerson" "AddressSeq" "" "" 4343 "" 4093 1
4050 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "" "" "1" "" 4346 "" 4055 4
4050 "AND" "" "StuBus" "SchoolHome" "=" "" "" "TRUE" "" 4491 "" 4084 2
4050 "Where" "" "busRouteBusX" "BusRouteSeq" "=" "StuBus" "BusRouteSeq" "" "" 4493 "" 4492 1
4050 "Where" "" "Bus" "BusSeq" "=" "busRouteBusX" "BusSeq" "" "" 4495 "" 4494 1
[END]
[MyQueryFields]
4050 4071 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 2
4050 4072 "Person" "LastName" "" "x(15)" "Last Name" no 3
4050 4073 "Person" "FirstName" "" "x(15)" "First Name" no 4
4050 4074 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 6
4050 4075 "Student" "GradeLevel" "" "X(2)" "GL" no 5
4050 4104 "Address" "Address1" "" "X(25)" "Address1" no 8
4050 4496 "Bus" "BusNo" "" ">>9" "Bus No" no 1
4050 4497 "Address" "StreetNo" "" "x(8)" "Street No" no 7
[END]
[MyQuerySort]
4050 4499 "Bus" "BusNo" yes "Count" 1 "Bus" "BusNo" yes
4050 4078 "Person" "FirstName" no "" 3 "" "" no
4050 4079 "Person" "LastName" no "" 2 "" "" no
[END]
[MyQueryDocs]
4050 4080 2 "Portrait" 0 "" ""
4050 4081 6 "Portrait" 0 "" ""
4050 4082 1 "Portrait" 0 "" ""
4050 4083 4 "" 0 "" ""
[END]