Looks like the following code might work:

SELECT a.StatusID, a.equipmentid,b.endate, a.StatusTypeID

FROM table1 INNER JOIN

(

SELECT equipmentid, max(enddate) as enddate FROM table1

Hi all,

I hope someone can help me with this. I have been racking my poor stupid brain for days over this. I need a way to be able to create a view of the data in a single table. Let's call it...