本文提供了一个具体的SQL查询案例，展示了如何通过联表查询的方式获取特定银行卡对应的不同类型的基金信息。通过对BankCardBusiInfo和Fundobj表进行连接，并根据cardbusitype筛选CorpFund和MemberFund类型的数据。
select * from Fund obj,(select bc.objid objid,
case when bc.cardbusitype=1 then 'CorpFund' when bc.cardbusitype=2 then 'CorpFund' when bc.cardbusitype=3 then 'MemberFund' else '' end cardbusitype
from BankCardBusiInfo bc left join bankcard b on bc.bankcardid = b.bankcardid
where b.ifUse=1 and b.cardNo = '9999990000000000010954')
ft where obj.objid = ft.objid and obj.discriminate = ft.cardbusitype;
case when bc.cardbusitype=1 then 'CorpFund' when bc.cardbusitype=2 then 'CorpFund' when bc.cardbusitype=3 then 'MemberFund' else '' end cardbusitype
from BankCardBusiInfo bc left join bankcard b on bc.bankcardid = b.bankcardid
where b.ifUse=1 and b.cardNo = '9999990000000000010954')
ft where obj.objid = ft.objid and obj.discriminate = ft.cardbusitype;
扫一扫
472
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
