[MyQuery]
2768 "BCarraherSIS" "Teachers Extra Security Options" "Teachers with their Extra Security Options"
[END]
[MyQueryTables]
2768 2769 1 "EACH" "Users" no 0
2768 2770 2 "FIRST" "usersUserType" no 0
2768 2772 3 "FIRST" "UserType" no 0
2768 2775 4 "FIRST" "Person" no 0
2768 2789 5 "EACH" "extraSecurity" no 0
[END]
[MyQueryWhere]
2768 "Where" "" "usersUserType" "PersonSeq" "=" "Users" "PersonSeq" "" "" 2771 "" 2770 1
2768 "AND" "" "UserType" "UserTypeDescr" "=" "" "" "Teacher" "" 2773 "" 2772 2
2768 "WHERE" "" "UserType" "UserTypeSeq" "=" "usersUserType" "UserTypeSeq" "" "" 2774 "" 2772 1
2768 "Where" "" "Person" "PersonSeq" "=" "Users" "PersonSeq" "" "" 2776 "" 2775 1
2768 "WHERE" "" "extraSecurity" "UsersID" "=" "Users" "UsersID" "" "" 2790 "" 2789 1
2768 "WHERE" "" "Users" "Active" "=" "" "" "Yes" "" 2792 "" 2769 1
[END]
[MyQueryFields]
2768 2777 "Users" "Active" "" "yes/no" "Active" no 5 0
2768 2778 "Person" "FirstName" "" "x(15)" "First Name" no 2 0
2768 2779 "Users" "UsersID" "" "x(10)" "User Id" no 3 0
2768 2780 "Person" "LastName" "" "x(15)" "Last Name" no 1 0
2768 2781 "UserType" "UserTypeDescr" "" "X(25)" "Description" no 4 0
2768 2791 "extraSecurity" "extraSecurityMnem" "" "X(8)" "Mnemonic" no 6 0
[END]
[MyQuerySort]
2768 2782 "Person" "FirstName" no "" 2 "" "" no
2768 2783 "Person" "LastName" no "" 1 "" "" no
2768 2784 "Users" "Active" no "" 3 "" "" no
[END]
[MyQueryDocs]
2768 2785 2 "Portrait" 0 "" ""
2768 2786 6 "Portrait" 0 "" ""
2768 2787 1 "Portrait" 0 "" ""
2768 2788 4 "" 0 "" ""
[END]