Modifying the Type of Join
Suppose the Fire and Ice Tours company wants to expand the number of tours that it offers in Europe. It wants to include in the list all the volcanoes in Europe, not just volcanoes that currently have tours. In SAS Enterprise Guide the default action of a join is to include only the rows that appear in both tables. To change this default action, you need to modify the join.
Right-click the query icon in the Project Explorer or Project Designer and select Open to reopen the query.
Click Join to ...