File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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