27,580
社区成员
发帖
与我相关
我的任务
分享
SELECT ISNULL((SELECT Name from dat_ShiftNote where TeamDate='2015-10-10'),'')
union ALL
SELECT ISNULL((SELECT Name from dat_ShiftNote where TeamDate='2015-10-11'),'')
UNION ALL
SELECT ISNULL((SELECT Name from dat_ShiftNote where TeamDate='2015-10-12'),'')
SELECT ISNULL((SELECT Name from dat_ShiftNote where TeamDate='2015-10-10'),'') AS [Name]
union ALL
SELECT ISNULL((SELECT Name from dat_ShiftNote where TeamDate='2015-10-11'),'') AS [Name]
UNION ALL
SELECT ISNULL((SELECT Name from dat_ShiftNote where TeamDate='2015-10-12'),'') AS [Name]