📄 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
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -