請教大家 我有一paradox 的資料庫,其內容包含整個月份資料,其欄位有Date1,Time1,Code 等,我如果想下sql指令,抓取如從'05/01/2003' 的'12:00' 到'05/03/2003'的'13:59',該如何下指令呢? Table的內容大致如下; Date1 Time1 Code ================================== 2003/05/01 00:01:10 01 2003/05/01 00:02:20 01 2003/05/01 01:10:25 02 ...... 2003/05/31 23:22:20 01

select * from tablename where (date1 = '05/01/2003' and time1 >= '12:00') or (date1 = '05/02/2003') or (date1 = '05/03/2003' and time1 <= '13:59') 中間的日子若有多天可用 (date1 between xxx and yyy)