why not something like below. Assume you have 3 pairs of start/end timestamps and you want to find everything within those 3 time periods:
select * from table_name where start >= start1 and end <= end1 union select * from table_name where start >= start2 and end <= end2 union select * from table_name where start >= start3 and end <= end3 On Fri, May 8, 2009 at 11:26 AM, Abhishek Pratap <abhishek....@gmail.com>wrote: > Hi All > > I am kind of stuck with this query , cant expand my thinking. May this is > a > limitation. Here it is > > I have a database with many cols two of which are start and end position > for > an event. > > Now I have a list of event time stamps, I want to find all the info once > the > current event time stamp is >= start time of event and <=end time of event. > > something like this > > select * from table_name where start <= ( LIST of time stamps) AND end >=( > list of time stamps). > > Clearly above query accepts only one item in the list. Is there a way to do > this for multiple items in the list ??? I can't think of anything at this > moment. > > > Thanks, > -Abhi > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com