白井です。 > date |start_time|end_time > ----------------------- > 2002-05-16 | 10:00:00 |13:00:00 空いてるかどうかを返すなら、 SELECT (count(*) = 0) FROM reserve WHERE (date = 'DATE_TO_RESERVE') AND (NOT ( 'ENDTIME_TO_RESERVE' < start_time OR end_time < 'STARTTIME_TO_RESERVE' ) ); でどうです? -- shirai @ p1jp.com Shirai,Kaoru PlusOne Co.,Ltd