Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Left outer join

 
Phillipe Rodrigues
Ranch Hand
Posts: 165
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
WHEN TO USE A LEFT OUTER JOIN?
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic