sql查询时，根据特定的条件给表的某一个字段赋值

执着的涛

于 2022-05-18 10:56:56 发布

阅读量3.6k

点赞数

分类专栏： SQL Server 文章标签： sql 数据库 database

本文链接：https://blog.csdn.net/beautifull001/article/details/124838075

版权

SQL Server 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

select a.id,a.Title,a.Receiver,a.IsRead,a.NotificationMethod,a.Creation_id,a.CreationTime,b.DeptName,c.CompanyName,(case when a.IsRead >0 then '已阅读' else '未读' end) as ReadStatus
  from [dbo].[res_Knowledge_MessagePush] a 
  left join res_Knowledge_PersonnelSkills b on a.Receiver = b.AD
  left join [dbo].[res_Knowledge_Company] c on b.RO = c.CompanyCode