SAS Data Integration Studio 4.9

Adding Subqueries

Problem

You want to add one or more subqueries to an existing SQL query by using the

Designer tab of the properties window for the SQL Join transformation.

Solution

Use the Subquery object in the Designer window to add a subquery to an SQL query.

The sample job used in “Add a Subquery as an Input Table” on page 470 adds a

subquery to an input table. This subquery reduces the amount of data that is processed in

the main SQL query because it runs and subsets data before the SELECT clause is run.

“Add a Subquery to an SQL Clause” on page 473 covers adding a subquery to a

SELECT, WHERE, or HAVING clause in an SQL query.

Perform the ...