DataFlux Data Management Studio 2.6: User Guide
You can use the Cross Join tab to define a cross join. Cross joins return the Cartesian product of the two tables included in the join. The Cross Join tab contains the following elements:
Left side - Specifies the table used for the left side of the join.
Join type - Enables you to select a different join type.
Right side - Specifies the table used for the right side of the join.
Switch sides - Enables you to switch the tables from one side of the join to the other. The table on the left side moves to the right side, and the table on right side moves to the left side.
Add parenthesis - Adds a parenthesis around the join in the SQL code.
Documentation Feedback: yourturn@sas.com
|
Doc ID: dfU_SQL_CrossJoin.html |