以下两段代码不等价
代码1: a LEFT JOIN b ON b.column = xxx
结果:b.default_flg的值为1或NULL,即a表中对应的b表中default_flg != 1的行也会保留,但不会关联b表
SELECT a.id, b.default_flg
FROM (
SELECT id, b_id
FROM table_a
) a
LEFT JOIN (
SELECT id, default_flg
FROM table_b
) b
ON
以下两段代码不等价
代码1: a LEFT JOIN b ON b.column = xxx
结果:b.default_flg的值为1或NULL,即a表中对应的b表中default_flg != 1的行也会保留,但不会关联b表
SELECT a.id, b.default_flg
FROM (
SELECT id, b_id
FROM table_a
) a
LEFT JOIN (
SELECT id, default_flg
FROM table_b
) b
ON