Thank you Jack.

But this does not work if i have more ids.

For each id its giving me all dates.But it should only give me max date within 5 days in...

Thank you.You are awe some.

This is a great help for beginner like me.

shipra20 (6/3/2009)

---

Hi All,

I have 2 tables as follows

Table1

ID-----NO------------Edate---

50----001------------2008-07-15

Table2

ID-----Edate---

50----2008-01-15

50----2008-07-13

REQUIRED Result should be a table with coloum 3 in Table2.If a record exists in Table1 within 5 days of Edate in...