از BOL
Left outer join All rows from the first-named table (the "left" table, which appears leftmost in the JOIN clause) are included. Unmatched rows in the right table do not appear
Right outer join All rows in the second-named table (the "right" table, which appears rightmost in the JOIN clause) are included. Unmatched rows in the left table are not included
Inner join A join that displays only the rows that have a match in both joined tables. (This is the default type of join in the Query Designer.)