Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

SQL Basics I: Data Queries—covers database terminology and the four basic query types. SQL Basics: SELECT statement options —covers the SELECT statement in detail and explains aggregate functions.

To change the Pass-Through query into a PROC SQL view, you add a PROC SQL CREATE VIEW statement to the query. You also remove the ORDER BY clause from the CONNECTION TO component and add it to a ...