sql.txt

自动回传考勤数据程序,小程序!大作用!可供大家参考一下!

SELECT * FROM Mac_BrushTimeLimit,Mac_FoodBrushCard where '09:00' between TimeFrom and TimeTo and LimitType='Food';

SELECT * FROM Mac_FoodCardNo,(select TimeFrom,TimeTo from Mac_BrushTimeLimit where TimeFrom<'20:43' and TimeTo>'20:43' and LimitType='Food') where Mac_FoodCardNo='0000328887' and Mac_FoodBrushTime between #2003/06/27 00:00# and #2003/06/27 23:59#

SELECT * FROM Mac_FoodBrushCard where Mac_FoodCardNo='0000328887' and Mac_FoodBrushTime between #2003/06/27 00:00# and #2003/06/27 23:59# and (select count(*) from Mac_BrushTimeLimit where TimeFrom<'20:43' and TimeTo>'20:43' and LimitType='Food')>0

13538690693