Lrobinson 93181 (8/6/2013)

---

I've gotten a little further

Step 1 query gets me this:

c_iD1 c_rep c_Date

11111 23 2010-09-06

11111 25 2010-10-06

In step 2 I need to look at different data from the same table and find records where c_iD1 = c_iD AND

my "last_date" is < c_Date in order to return:

c_iD1 c_rep1 c_Date c_rep last_dt

11111 23 2010-09-06 25 2010-09-03

11111 25 2010-10-06 28 2010-10-02

I did not include the column "last_dt" in the create #mytable code simply to keep the first step simple, but basically, it is selected from #mytable in step 2 and compared to c_Date from ther first query.