Agenda
PS Query Subqueries - They are JUST criteria ... yeah right!
Track: Technical and Reporting
Session Number: 9557
Date: Tue, Feb 28th, 2023
Time: 9:00 AM - 10:00 AM
Description:
This presentation is an in depth look at subquery uses with examples and context. Understanding the value of subqueries and how to properly construct them. Understanding the available options are essential to the query writer's toolbox.
You ARE already writing subqueries (with Eff Date operators).
If they are criteria, what aren’t they?
Exists or not Exists
In list or not in list
(Not) Equal To, (Not) Greater Than, (Not) Less Than
Selecting the field/expression
Subquery/Union Navigation
You ARE already writing subqueries (with Eff Date operators).
If they are criteria, what aren’t they?
Exists or not Exists
In list or not in list
(Not) Equal To, (Not) Greater Than, (Not) Less Than
Selecting the field/expression
Subquery/Union Navigation
Sub-Categorization: Other
Session Type: Presentation
Session Length: Regular Length (60 min)
Cross Listed Areas: trk-1603, trk-1593, trk-1598
ERP Systems: PeopleSoft
Platform Type: N/A
Target Audience: All
Knowledge level: Intermediate
Tell us about you!: I am the Reporting Team Lead for the Campus Solutions Student System at the Pennsylvania State University. I have 7 years of experience using and training PS Query. I am a past presenter, Alliance 2022 - "Outer Join Schmouter Join". I am certified in Microsoft SQL Server and a Project Management Professional.
Sub-Categorization: Other
Session Type: Presentation
Session Length: Regular Length (60 min)
Cross Listed Areas: trk-1603, trk-1593, trk-1598
ERP Systems: PeopleSoft
Platform Type: N/A
Target Audience: All
Knowledge level: Intermediate
Tell us about you!: I am the Reporting Team Lead for the Campus Solutions Student System at the Pennsylvania State University. I have 7 years of experience using and training PS Query. I am a past presenter, Alliance 2022 - "Outer Join Schmouter Join". I am certified in Microsoft SQL Server and a Project Management Professional.
Speakers
Primary Presenter
Robert Fogarty, PMP
Reporting Team Lead | LionPATH Development and Maintenance Office
The Pennsylvania State University
