34,576
社区成员
发帖
与我相关
我的任务
分享
select distinct a.fundcode,a.fundnameabbr,a.pinyincode
from tb_fundarchive a ,tb_fundnetvalue b
where a.isdeleted = 0 and a.fundtype = 7 and a.fundcode = b.fundcode
and (a.fundcode like '%021%' or a.pinyincode like '%021%' or a.fundname like '%021%' or a.fundnameabbr like '%021%')
select distinct a.fundcode,a.fundnameabbr,a.pinyincode
from tb_fundarchive a ,tb_fundnetvalue b
where a.isdeleted = 0 and a.fundtype = 7
and a.fundcode = b.fundcode---注意内连接要有符合的条件,否则就查不到数据。
and (a.fundcode like '%021%' or a.pinyincode like '%021%'
or a.fundname like '%021%' or a.fundnameabbr like '%021%')