各位大俠,小弟有學習不久有個問題須請教:
Tabel1: Order1:Order: char(20) Line:char(20)Box_Num:char(10)Operator:char(10)inputdatetime:datetime,Tabel2: Order2: Order: char(20) Line:char(20)Box_Num:char(10)Operator:char(10)inputdatetime:datetimeTabel3: Order_information:Order:char(20);MO Q’TY:integer;我現在要查詢 字段:Order1.*,order2.*,Order_information.Mo條件: Order1與Order2的 inputdatetime 的時間在2007/3/8 08:00:00至2007/3/8 12:00:00的記錄 在這個時間范圍內兩個Label中都有記錄
Tabel1: Order1:Order: char(20) Line:char(20)Box_Num:char(10)Operator:char(10)inputdatetime:datetime,Tabel2: Order2: Order: char(20) Line:char(20)Box_Num:char(10)Operator:char(10)inputdatetime:datetimeTabel3: Order_information:Order:char(20);MO Q’TY:integer;我現在要查詢 字段:Order1.*,order2.*,Order_information.Mo條件: Order1與Order2的 inputdatetime 的時間在2007/3/8 08:00:00至2007/3/8 12:00:00的記錄 在這個時間范圍內兩個Label中都有記錄
解决方案 »
- 画透明矩形
- 请教一个关于Random问题
- 郁闷,新装了D2007,却不懂怎么打开原来的DPR工程文件来编辑里面的代码
- 棋牌游戏新开张,欢迎大家来测试!
- dbgrid中复制当前项的上一行记录
- 谁有高级程序员分数查询的网址,告诉我。还是没有下分。(在线等)!!马上结帖
- SelectDirectory函数的用法
- delphi如何调用com组件的dll 求大神 最好有一个成功的代码
- 能使Query實現類似在Table中FindNearest的模糊查找功能﹖高分求救﹗
- 谁讲得透分给谁,都是些初级问题。
- 如何在dbgrid或者dbgrideh中显示两次以上的查询内容???
- 年终奖发了多少,大家都来说说看!!
select Order1.*, order2.*, Order_information.Mo
from Order1, Order2, Order_information
where order2.order = order1.order
and Order_information.order = order1.order
and order1.inputdatetime >= '2007-3-8 08:00:00'
and order1.inputdatetime <= '2007-3-8 12:00:00'
and order2.inputdatetime >= '2007-3-8 08:00:00'
and order2.inputdatetime <= '2007-3-8 12:00:00'
from Order1, Order2, Order_information
where order2.order = order1.order
and Order_information.order = order1.order
and (order1.inputdatetime between '2007-3-8 08:00:00' and '2007-3-8 12:00:00')
and (order2.inputdatetime between '2007-3-8 08:00:00' and '2007-3-8 12:00:00')