LEFT OUTER JOIN(左外连接)接收左表的所有行,并用这些行与右表进行匹配
SELECT b.boy,t.toy
FROM boys b
LEFT OUTER JOIN toys t
ON b.toy_id=t.toy_id;
LEFT OUTER JOIN左边的表boys我们称为左表,右边的toys称为右表,所以LEFT OUTER JOIN会取得左表boys的所有行和右表的toys的行进行匹配
RIGHT OUTER JOIN左侧的表为右表!!!
SELECT b.boy,t.toy
FROM toys t
RIGHT OUTER JOIN boys b
ON b.toy_id=t.toy_id;
等价于
SELECT b.boy,t.toy
FROM boys b
LEFT OUTER JOIN toys t
ON b.toy_id=t.toy_id;
这两种写法都是都把toys作为右表,把boys作为左表