left join union all right join 后怎么产笛卡尔积了?
SELECT * FROM web a LEFT JOIN com b ON a.name = b.company_name UNION ALL SELECT * FROM web a RIGHT JOIN com b ON a.name = b.company_name
这样查询的结果:
是哪里写错了吗?
SELECT * FROM web a LEFT JOIN com b ON a.name = b.company_name UNION ALL SELECT * FROM web a RIGHT JOIN com b ON a.name = b.company_name
这样查询的结果:
是哪里写错了吗?
2016-12-03
举报