PS Query & SQL

This session reviews query basics for new users. It provides a listing of frequently used tables and fields. We will also review some “generic” queries. These queries serve two purposes: (1) to allow staff members who do not have query manager to get data quickly and easily without having to ask for a new query, and (2) to provide a basis for more complex queries (i.e. do not need to start from scratch).

If time permits, we will dig into more advanced topics, such as case statements in expressions, in-list or not-in-list with subqueries and unions.

https://www.heug.org/communities/community-home/librarydocuments/viewdocument?DocumentKey=ad10bad6-e27b-4c39-9ce8-26c6b65ca526

#Ellen_Fishman
#Theresa_Allen
#PSQuery
#Basics
#New_staff