The SQL Join transformation
enables you to create SQL queries that run in the context of SAS Data
Integration Studio jobs. The transformation features a graphical interface
that provides a consistent and intuitive setting for building the
statements and clauses that constitute queries. The transformation
supports the PROC SQL syntax of
Create table/view <table>
as <query expression> and accommodates up to 256
tables in a single query. The Select statement supports joining the
table to itself. It also supports subqueries; the CASE expression;
and WHERE, GROUP BY, HAVING, and ORDER BY clauses.
The process
of building the SQL query is performed in the
Designer window. You access this window when you double-click the SQL Join
transformation in a SAS Data Integration Studio job. You use the
Designer window to create, edit, and review an SQL query.
The window contains sections that are designed to simplify creating
the SQL query and configuring its parts. To return to the SQL job
on the
Designer tab of the
Job
Editor window, click
Up on the
toolbar.
The SQL
Join transformation supports the pushdown feature that enables you
to process relational database tables directly on the appropriate
relational database server. For information about pushdown, see
Pushing Job Code down to a Database.