sqlhints.com
Difference between RIGHT JOIN and RIGHT OUTER JOIN in Sql Server
Frankly speaking, in Sql Server there is no difference between RIGHT JOIN and RIGHT OUTER JOIN. They produce the same result and also the same performance. Let us prove with examples that there is …