select a.*,b.mm,b.nn from aaaaa a left join bbbbb b on trim(a.num)=trim(b.num)
where b.cc = '11'
你所说的运行之后只显示10万数据
可能是应为 where b.cc = '11'
想全部显示a表数据
select a.*,b.mm,b.nn from aaaaa a
left join bbbbb b on ( trim(a.num)=trim(b.num) and b.cc = '11')
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024