left join on +多条件与where区别
SELECT
*
FROM
aaa,
bbb;
SELECT
*
FROM
aaa A
LEFT JOIN bbb b ON A . ID = b. ID;
SELECT
*
FROM
aaa A
LEFT JOIN bbb b ON A . ID = b. ID and a.id =1;
SELECT
*
FROM
aaa A
LEFT JOIN bbb b ON A ....
原创
2018-06-19 17:52:39 ·
4151 阅读 ·
0 评论