Have cleaned it up
SELECT MAX(ClassResult .ClassID) AS LASTCLASS,
Person.PersonID ,
Person.LastName ,
Person.FirstNam e,
Address.Address 1,
Address.City,
Address.State,
Address.Zip,
Class.Year,
ClassResult.Cla ssResultStatusI D
FROM Person

INNER JOIN Person_Address ON Person.PersonID = Person_Address. PersonID
INNER...

I am new to sql and have not been able to resolve this issue. I have a query that shows me the information on students we serve. The query pulls all of their classes and the status results as well as contact information. I need to query down to the LAST class taken and the students status. If I take out the following fields I get the correct return but I have to have all the information dbo.Class.Year, dbo.ClassResult .ClassResultSta tusID, dbo.Class.Semes terID,...