Working with SQL Join Transformations

About SQL Join Transformations

Using the Designer Window

Reviewing and Modifying Clauses, Joins, and Tables in an SQL Query

Understanding Automatic Joins

Selecting the Join Type

Adding User-Written SQL Code

Debugging an SQL Query

Adding a Column to the Target Table

Adding a Join to an SQL Query on the Designer Tab

Creating a Simple SQL Query

Configuring a SELECT Clause

Adding a CASE Expression

Creating or Configuring a WHERE Clause

Adding a GROUP BY Clause and a HAVING Clause

Adding an ORDER BY Clause

Adding Subqueries

Validating or Submitting an SQL Query

Joining a Table to Itself

Using Parameters with an SQL Join

Constructing a SAS Scalable Performance Data Server Star Join

Optimizing SQL Processing Performance

Performing General Data Optimization

Influencing the Join Algorithm

Setting the Implicit Property for a Join

Enabling Pass-Through Processing

Using Properties Window Options to Optimize SQL Processing Performance

Copyright © SAS Institute Inc. All rights reserved.