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 . ID = b. ID where b.id =1;
left join on +多条件与where区别
最新推荐文章于 2023-09-14 19:15:55 发布