Sqlserver case...when + union 用法

发布时间：2020-12-12 13:39:24 所属栏目：MsSql教程来源：网络整理

导读：SELECT a.user_id,a.package_id,a.addtime,a.result,b.package_name + '' + b.package_price + '' + b.package_traffic+ '' + case b.type when 1 then '（后付费）' else '（预付费）' END package_name FROM xzllgj_user_traffic a LEFT JOIN xzllgj_traff

SELECT a.user_id,a.package_id,a.addtime,a.result,b.package_name + '' + b.package_price + '' + b.package_traffic+ '' + case b.type when 1 then '（后付费）' else '（预付费）' END package_name FROM xzllgj_user_traffic a LEFT JOIN xzllgj_traffic_package b ON a.package_id = b.package_id WHERE user_id = 'xxxxx' UNION SELECT c.user_id,c.package_id,c.addtime,c.result,d.package_name + '' + d.package_price + '' + d.package_traffic+ '' + case d.type when 1 then '（后付费）' else '（预付费）' END package_name FROM xzllgj_user_traffic_failure c LEFT JOIN xzllgj_traffic_package d ON c.package_id = d.package_id WHERE user_id = 'xxxxx'

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!