SELECT *
FROM table1
LEFT JOIN table2 ON COALESCE(table1.id, 0) = COALESCE(table2.id, 0);
left join 的两个字段都是null
最新推荐文章于 2024-07-03 18:02:25 发布
SELECT *
FROM table1
LEFT JOIN table2 ON COALESCE(table1.id, 0) = COALESCE(table2.id, 0);