[MyQuery]
1916 "cpsimg9408" "Published Documents with User" "Published Documents with User Information"
[END]
[MyQueryTables]
1916 1917 1 "EACH" "UserDocuments" no 0
1916 1918 2 "EACH" "Users" no 0
1916 1920 3 "FIRST" "Person" no 0
1916 1922 4 "FIRST" "PublishedDocs" no 0
1916 1938 5 "EACH" "Student" no 0
1916 1940 6 "EACH" "bPerson" yes 0
1916 1968 7 "EACH" "usersUserType" no 0
1916 1970 8 "EACH" "UserType" no 0
[END]
[MyQueryWhere]
1916 "WHERE" "" "bPerson" "PersonSeq" "=" "Student" "personSeq" "" "" 1941 "" 1940 1
1916 "Where" "" "usersUserType" "PersonSeq" "=" "UserDocuments" "PersonSeq" "" "" 1969 "" 1968 1
1916 "Where" "" "Users" "PersonSeq" "=" "UserDocuments" "PersonSeq" "" "" 1919 "" 1918 1
1916 "Where" "" "Person" "PersonSeq" "=" "UserDocuments" "PersonSeq" "" "" 1921 "" 1920 1
1916 "WHERE" "" "PublishedDocs" "PublishedDocsSeq" "=" "UserDocuments" "PublishedDocsSeq" "" "" 1923 "" 1922 1
1916 "WHERE" "" "Student" "StudentID" "=" "UserDocuments" "StudentID" "" "" 1939 "" 1938 1
1916 "Where" "" "UserType" "UserTypeSeq" "=" "usersUserType" "UserTypeSeq" "" "" 1971 "" 1970 1
[END]
[MyQueryFields]
1916 1924 "UserDocuments" "Viewed" "" "yes/no" "Viewed" no 4 0
1916 1925 "Person" "LastName" "" "x(15)" "Last Name" no 5 0
1916 1926 "Person" "FirstName" "" "x(15)" "First Name" no 6 0
1916 1927 "UserDocuments" "TotalDownloads" "" ">>>>>>>>>9" "TotalDownloads" no 8 0
1916 1928 "PublishedDocs" "PublishDate" "" "99/99/99" "PublishDate" no 2 0
1916 1929 "UserDocuments" "FileName" "" "x(8)" "FileName" no 1 0
1916 1930 "Users" "UsersID" "" "x(8)" "User ID" no 3 0
1916 1942 "bPerson" "LastName" "" "x(15)" "Student Last Name" no 10 0
1916 1943 "bPerson" "FirstName" "" "x(15)" "Student First Name" no 11 0
1916 1937 "UserDocuments" "StudentID" "" "ZZZZZZZ9" "Student ID" no 9 0
1916 1972 "UserType" "UserTypeDescr" "" "X(25)" "Description" no 7 0
[END]
[MyQuerySort]
1916 1931 "Person" "FirstName" no "" 3 "" "" no
1916 1932 "Person" "LastName" no "" 2 "" "" no
1916 1933 "UserDocuments" "FileName" yes "Count" 1 "" "" no
[END]
[MyQueryDocs]
1916 1936 4 "" 0 "" ""
1916 1934 2 "" 0 "" ""
1916 1935 6 "" 0 "" ""
[END]