版主您好：能否大概讲一下SQL语句的条件判断的呢，比如我想写在“字段填充”里的条件判断，能否说一下判断的语法呢，非常感谢！

可以参考一下我写的SELECT DISTINCT [T_4].[F_59] AS 本报表.[F_124]xFN, [T_15].[F_62] AS 本报表.[F_125]xFN, [T_15].[F_63] AS 本报表.[F_126]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='1'and  [T_4].[F_59]= 本报表.[F_161]   THEN F_73 END) AS 本报表.[F_127]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='2'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_128]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='3'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_129]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='4'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_130]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='5'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_131]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='6'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_132]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='7'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_133]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='8'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_134]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='9'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_135]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='10'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_136]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='11'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_137]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='12'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_138]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='13'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_139]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='14'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_140]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='15'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_141]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='16'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_142]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='17'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_143]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='18'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_144]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='19'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_145]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='20'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_146]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='21'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_147]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='22'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_148]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='23'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_149]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='24'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_150]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='25'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_151]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='26'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_152]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='27'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_153]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='28'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_154]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='29'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_155]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='30'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_156]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='31'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_157]xFN  FROM  [T_4] LEFT JOIN [T_15] On [T_4].[ID] = [T_15].[ID] GROUP BY [T_4].[F_59] ,[T_15].[F_62] ,[T_15].[F_63], YEAR( [T_4].[F_60] ), month([T_4].[F_60])  

可以参考一下我写的SELECT DISTINCT [T_4].[F_59] AS 本报表.[F_124]xFN, [T_15].[F_62] AS 本报表.[F_125]xFN, [T_15].[F_63] AS 本报表.[F_126]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='1'and  [T_4].[F_59]= 本报表.[F_161]   THEN F_73 END) AS 本报表.[F_127]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='2'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_128]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='3'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_129]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='4'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_130]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='5'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_131]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='6'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_132]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='7'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_133]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='8'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_134]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='9'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_135]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='10'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_136]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='11'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_137]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='12'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_138]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='13'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_139]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='14'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_140]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='15'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_141]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='16'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_142]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='17'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_143]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='18'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_144]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='19'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_145]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='20'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_146]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='21'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_147]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='22'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_148]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='23'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_149]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='24'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_150]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='25'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_151]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='26'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_152]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='27'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_153]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='28'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_154]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='29'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_155]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='30'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_156]xFN, SUM(CASE WHEN YEAR(F_60)= 本报表.[F_159]  AND MONTH(F_60)= 本报表.[F_160] AND DAY(F_60)='31'and  [T_4].[F_59]= 本报表.[F_161] THEN F_73 END) AS 本报表.[F_157]xFN  FROM  [T_4] LEFT JOIN [T_15] On [T_4].[ID] = [T_15].[ID] GROUP BY [T_4].[F_59] ,[T_15].[F_62] ,[T_15].[F_63], YEAR( [T_4].[F_60] ), month([T_4].[F_60])