• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

left outer and right outer joins

 
Dale DeMott
Ranch Hand
Posts: 515
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Isn't a left outer join the same as a right outer join.. just a matter of order. If there was no right outer join, you could reorder the tables and do what you need with the left. Correct?
 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Correct.

It's often nice to standardize on using just one or the other in your code, to make the queries a little more consistent and thereby more readable, but that's certainly optional.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic