Roy Harvey
3/20/2007 5:16:00 PM
RIGHT JOIN and RIGHT OUTER JOIN are exactly the same thing. As soon
as RIGHT or LEFT is specified by definition that makes it OUTER, but
the work OUTER is optional and may be left out.
Roy Harvey
Beacon Falls, CT
On Tue, 20 Mar 2007 17:56:27 +0100, "Lasse Edsvik" <lasse@nospam.com>
wrote:
>Hello
>
>Could someone explain the differences between RIGHT OUTER JOIN and RIGHT
>JOIN?
>
>If outer allows a table to have nulls and right join dont, wouldnt make any
>sense since there are inner join in that case.
>
>/Lasse