----

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 ..