56,675
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#Finalscore') is null
drop table #Finalscore
Go
Create table #Finalscore([employeeID] int,[number] nvarchar(76))
Insert #Finalscore
select 6024,N'A344A1531975312940,A344A1531975362963,A344A1531975490965' union all
select 9956,N'A344A1531975312940,A344A1531975362963,A344A1531975490965' union all
select 1441,N'A344A1531975312940,A344A1531975362963,A344A1531975490965' union all
select 2573,N'A344A1531975312940,A344A1531975362963,A344A1531975490965'
GO
if not object_id(N'Tempdb..#Singlescore') is null
drop table #Singlescore
Go
Create table #Singlescore([employeeID] int,[number] nvarchar(38))
Insert #Singlescore
select '9956',N'A344A1531975312940'
Go
--测试数据结束
SELECT #Finalscore.*,
CASE
WHEN #Singlescore.number IS NOT NULL THEN
'Yes'
ELSE
''
END captain
FROM #Finalscore
LEFT JOIN #Singlescore
ON #Singlescore.employeeID = #Finalscore.employeeID;
SELECT fs.*, IF(fs.employeeID=ss.employeeID,'Yes','') captain
FROM Finalscore fs, Singlescore ss
where FIND_IN_SET(ss.number, fs.number)