左关联之后,数据重复怎么解决
这种重复就得看你逻辑了吧。检查下关联条件是否缺失
select * from
(select * from b where xxx) a
left join (select * from b where xxx)b on a.xx=b.xx
先用子查询过滤在关联试试