各位大俠,小弟有學習不久有個問題須請教:
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中都有記錄
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')