Use the
Designer window for the SQL transformation to create,
edit, and review an SQL query. You access this window when you double-click
the SQL Join in a SAS Data Integration Studio job. (You can also right-click
the transformation and click
Open in the
pop-up menu.) The window contains sections that are designed to simplify
creating the SQL query and configuring its parts.