This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC and the fly likes Left outer join Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Left outer join" Watch "Left outer join" New topic

Left outer join

Phillipe Rodrigues
Ranch Hand

Joined: Oct 30, 2007
Posts: 165

Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Typically you would use this when you have a nullable foreign key or some other situation when you want stuff in the left table returned, regardless of whether there are any matching results on the right side of the join.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link:
subject: Left outer join
Similar Threads
SQL Join for two different columns
How to use Left outer join in EJB 3.0
are these join same
left outer join Vs right outer join
Joining 3 Tables