SELECT
a *,
b.*
FROM
table_a a
LEFT JOIN table_b b
ON a.id = b.aid
LEFT JOIN table_c
ON a.id = c.aid
多表关联left join
最新推荐文章于 2024-07-13 16:28:12 发布
SELECT
a *,
b.*
FROM
table_a a
LEFT JOIN table_b b
ON a.id = b.aid
LEFT JOIN table_c
ON a.id = c.aid