mysql两个表,name字段相同(但不完全重合),把values字段整合到查询结果

select t1.name,t2.values,t3.valuesfrom(select name from aunionselect name from b) t1 left join a t2 on t1.name=t2.nameleft join b t3 on t1.name=t3.name 恩，看出来了