问个超简单的查询语句，在线急等

[zoujiaming]

为何我
SELECT Max(Temperature0) as MaxTemperature0,nDate FROM MeteTable Where RecorderID='00001' And IsCable=True Group by nDate

提示我至少有一个参数未负值呀？

[WWWWA]

SELECT Max(Temperature0) as MaxTemperature0,nDate FROM MeteTable Where RecorderID='00001' And IsCable Group by nDate

or

SELECT Max(Temperature0) as MaxTemperature0,nDate FROM MeteTable Where RecorderID='00001' And IsCable=-1 Group by nDate

检查字段是否存在

[zoujiaming]

wwwwa老大，不行，我本想
SELECT Max(Temperature0) as MaxTemperature0,nDate,Evaporation FROM MeteTable Where RecorderID='00001' And IsCable=True Group by nDate

但只要加了MAX好像就不行，不知道为什么

[WWWWA]

Temperature0字段类型？

[zoujiaming]

找到问题了，谢谢wwwa老大