| Author |
Left Outer Join Vs Left Join
|
Dale DeMott
Ranch Hand
Joined: Nov 02, 2000
Posts: 514
|
|
|
So in the office we're debating over what is named what and what each mean. What is the difference between an left outer join and a left join? Many documents show that left outer is the same as a left. What are your thoughts?
|
By failing to prepare, you are preparing to fail.<br />Benjamin Franklin (1706 - 1790)
|
 |
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26201
|
|
Dale,
It's the same thing. An inner join, also known as a join, doesn't include nulls. By definition, it is an outer join if you specify a direction.
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
 |
|
|
subject: Left Outer Join Vs Left Join
|
|
|
0
