随笔59 SQL Left Join, Right Join, Inner Join, and Natural Join
1 A LEFT JOIN B = A LEFT OUTER JOIN B
2 A RIGHT JOIN B = A RIGHT OUTER JOIN B
3 A FULL JOIN B = A FULL OUTER JOIN B
4 A INNER JOIN B = A JOIN B
1 A LEFT JOIN B = A LEFT OUTER JOIN B
2 A RIGHT JOIN B = A RIGHT OUTER JOIN B
3 A FULL JOIN B = A FULL OUTER JOIN B
4 A INNER JOIN B = A JOIN B