Skip to Main Content
SAS Data Integration Studio 4.9
book

SAS Data Integration Studio 4.9

by SAS Documentation
August 2014
Intermediate to advanced content levelIntermediate to advanced
808 pages
25h 30m
English
SAS Institute
Content preview from SAS Data Integration Studio 4.9
INVOICE.ITEMSINSTOCK = PRODUCT.ITEMSINSTOCK and
PRODUCT.ITEMSINSTOCK = ITEMSINSTOCK.ITEMSINSTOCK
Selecting the Join Type
Problem
You want to select a specific type for a join in an SQL query. You can use the join type
selection to gain precise control over the data that is included in the results of the query.
Solution
Right-click an existing join in an SQL query, and click the appropriate join type in the
pop-up menu to select a different join type.
Tasks
Change Join Types in a Sample SQL Query
Examine a sample SQL query in a SAS Data Integration Studio job to see the effects of
changing the join types that are used in the query. The sample query contains ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

A Gentle Introduction to Statistics Using SAS Studio in the Cloud

A Gentle Introduction to Statistics Using SAS Studio in the Cloud

Ron Cody

Publisher Resources

ISBN: 9781629593098