Left Join
and Left Outer Join
are one inand the same. The former is the shorthand for the latter. The same can be said about the Right Join
and Right Outer Join
relationship. The demonstration will illustrate the equality. Working examples of each query have been provided via SQL Fiddle. This tool will allow for hands on manipulation of the query.
Given
Results
Right Join and Right Outer Join
Results