This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Left outer join" Watch "Left outer join" New topic
Author

Left outer join

Phillipe Rodrigues
Ranch Hand

Joined: Oct 30, 2007
Posts: 165
WHEN TO USE A LEFT OUTER JOIN?


Thanks,
Paul Sturrock
Bartender

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
 
Don't get me started about those stupid light bulbs.
 
subject: Left outer join
 
Similar Threads
Joining 3 Tables
are these join same
How to use Left outer join in EJB 3.0
SQL Join for two different columns
left outer join Vs right outer join