大家帮我看一下这句sql语句有没语法错误？？谢谢！！！
"select Event.*,Employee.Name,Employee.CardPhyID,Employee.CardID from Event,Employee where Employee.CardPhyID = Event.CardPhyID and ( Employee.Name = '1' or Employee.Name = '李春华' or Employee.Name = '李春华8' or Employee.Name = '班次测1' or Employee.Name = '临界班测1' or Employee.Name = '月测试普通白班1' or Employee.Name = '月测试普通白班2' or Employee.Name = '111111111111' or Employee.Name = '月测试临界班1' or Employee.Name = '月测试打卡临界1' or Employee.Name = '月测试打卡临界早' or Employee.Name = 'xxx' or Employee.Name = '456456') and EventTime BETWEEN '2005-01-24 14:41:16' and '2005-01-24 14:41:16' and IsAlarm=255 " 问题点数：10、回复次数：2Top
1 楼libin_ftsafe（子陌红尘：TS for Banking Card）回复于 2005-01-24 15:17:28 得分 0
将"EventTime BETWEEN '2005-01-24 14:41:16' and '2005-01-24 14:41:16'"用()括起来。Top
2 楼zpsinz（青空有雾）回复于 2005-01-24 15:25:04 得分 10
and ( Employee.Name = '1' or Employee.Name = '李春华' or Employee.Name = '李春华8' or Employee.Name = '班次测1' or Employee.Name = '临界班测1' or Employee.Name = '月测试普通白班1' or Employee.Name = '月测试普通白班2' or Employee.Name = '111111111111' or Employee.Name = '月测试临界班1' or Employee.Name = '月测试打卡临界1' or Employee.Name = '月测试打卡临界早' or Employee.Name = 'xxx' or Employee.Name = '456456')
这一段为什么不用in语句呢?可以简洁许多。
IsAlarm=255 是属于哪张表的？最好清楚给出。
Top
