A LEFT JOIN B
ON A.id = B.id
AND B.deleted IS NULL (条件跟在ON条件里面,先筛选B表的记录,然后根据A表返回A表所有行
WHERE A.deleted IS NULL
结果: 2 大明 NULL
A LEFT JOIN B ON A.id = B.id
WHERE A.deleted IS NULL
AND B.deleted IS NULL (条件在外面,先根据A表返回所有记录,然后根据B表条件删除记录
A表
id | name | deleted |
1 | 小明 | 2017-01-10 |
2 | 大明 | NULL |
B表
id | age | deleted |
2 | 15 | 2017-01-11 |