• 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.
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!