Help using Base SAS procedures

left join vs left outer join

Accepted Solution Solved
Reply
Super Contributor
Posts: 276
Accepted Solution

left join vs left outer join

Is there any difference between left join and left outer join??????

please clarify me..


Accepted Solutions
Solution
‎01-23-2012 09:13 AM
Super User
Posts: 5,256

Re: left join vs left outer join

Well, the answer is No. From the paper:

"Often you will hear the "left outer join" referred to as just the "left join". This is because the code that creates the join uses only the keyword "left join". The terms, however, are synonymous. "

/Linus

Data never sleeps

View solution in original post


All Replies
PROC Star
Posts: 7,363

left join vs left outer join

Yes.  A nice description, I think, is shown and described in the paper: http://www2.sas.com/proceedings/sugi30/249-30.pdf

It compares sql joins with data step merge operations, and shows the various merges and joins in terms of a venn diagram.

Solution
‎01-23-2012 09:13 AM
Super User
Posts: 5,256

Re: left join vs left outer join

Well, the answer is No. From the paper:

"Often you will hear the "left outer join" referred to as just the "left join". This is because the code that creates the join uses only the keyword "left join". The terms, however, are synonymous. "

/Linus

Data never sleeps
Regular Contributor
Posts: 184

Re: left join vs left outer join

It's documented (http://support.sas.com/documentation/cdl/en/sqlproc/63043/HTML/default/viewer.htm#p1bk7i6jqseje7n1li...):

"Outer joins are inner joins that have been augmented with rows that did not match with any row from the other table in the join.".

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 14746 views
  • 1 like
  • 4 in conversation