select a.custno+'|'+a.custname as key1,
a.*,
b.EnterpriseName,
c.TypeName,
d.CareCenterName,
convert(nvarchar(10),BirthdayDate,120) as birthdate1,
RegisterType1=case
when RegisterType=1 then '前台登记'
when RegisterType=2 then '管理员登记'
else 'PC个人客户端登记'
end
from CustBaseInfo a left join SportFactoryDB.dbo.EnterPriseInfo b on a.EnterpriseID=b.id left join CertificateType c on a.CertificateType=c.CertificateID left join HealthCareCenter d on a.CareCenterNo=d.CareCenterNo
sql 判断某字段值输出不同的值
最新推荐文章于 2023-11-03 11:02:23 发布