Please help ... SQL query

:confused::confused:

----

From the HISTORY table we want to Fetch data that is 3 days prior to and 3 days after each of the EVENT_D We do not want the repeat history if the Incident_day events make this data overlap.

EX. Incident-date = 2/18/2011 3 days prior is 2/15 3 days after is 2/21
Incident-date = 2/202011 3 days prior is 2/17 3 days after is 2/23

In this case the data from 2/18 2/21 would be repeated. Only show that once, the Fetch should get the data from 2/15 2/23.


---- can you please help me in writing the query ..

Can you clarify further with table definition. What are you trying to select? Is there more than one condition in the query?, how are two incident_involved?