疑惑（1）

（1）SELECT [goods_code], client_code,[warehouse_code], sum([inputsub_checkamount]) as [inputsub_checkamount], sum([inputsub_checkamount]*[inputsub_price]) as [inputsub_checkamountMoney] FROM View_Input] where [warehouse_code] = '02' and year([inputmain_time]) =2009 AND month([inputmain_time])=4 AND [goods_code]='CP357013' AND client_code='07' group by goods_code,client_code,warehouse_code（2）select * from view_inputwhere year([inputmain_time])=2009 AND month([inputmain_time])=4为什么代码一，查询不到结果，而代码二可以查到结果。甚至代码一改成 cast(year([inputmain_time]) as varchar(4))=‘2009’ ANDcast(month([inputmain_time]) as varchar(4))=‘4’ 也不行简单的sql也可以让我发狂。