I have a table TABLE1 which has date field in it say TXN_DATE and i have a another table TABLE2 which also have a date field in it with name TXN_DATE i need to match the record from both the table where TABLE1.TXN_DATE is in between the +3 or -3 days of TABLE2.TXN_DATE .I have a table TABLE1 which has date field in i