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

解决方案 »

  1.   

    试试这个:
    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'
      

  2.   

    sql里有一个自带的判断函数,between什么什么的。。忘鸟。。
      

  3.   

    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 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')