Help in matching query

Here is a query that will get you the results you are looking for:

 SELECT 
 Credit.main_code, 
 Credit.code, 
 Credit.code1, 
 Credit.date1, 
 Credit.cost_code
 FROM #credit as Credit INNER JOIN
 (
 SELECT main_code, code, MAX(date1) as date1
 FROM #credit
 GROUP BY main_code, code
 ) as MostRecent
 ON Credit.main_code = MostRecent.main_code 
 AND Credit.code = MostRecent.code 
 AND Credit.date1 = MostRecent.date1
 ORDER BY Credit.main_code, Credit.code

---

Martina White