SELECT *
FROM (SELECT *
FROM orderformdetail
WHERE (deliverydatetime > 2003 - 3 - 10)) DERIVEDTBL
WHERE (deliverydatetime < 2004 - 3 - 21)
FROM (SELECT *
FROM orderformdetail
WHERE (deliverydatetime > 2003 - 3 - 10)) DERIVEDTBL
WHERE (deliverydatetime < 2004 - 3 - 21)
VarTime>'2003-2-12' and VarTime<'2003-3-1'
或者
VarTime between '2003-2-12' and VarTime<'2003-3-1' --这条语句包括边界时间
BETWEEN AND
在企业管理器中,运行如下,得不到数据,为何
用大于,得到全部的数据
SELECT *, orderform.*
FROM orderform
WHERE (orderdate < 2004 - 3 - 25)
FROM orderformdetail
WHERE (deliverydatetime BETWEEN 2003 - 3 - 3 AND 2003 - 3 - 31)没有数据显示