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
