PS Query & SQL

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

https://www.heug.org/communities/community-home/librarydocuments/viewdocument?DocumentKey=70c5ba48-467f-4402-beab-4b6edb93be95