Last Date Attended from 2 Tables MS SQL : I have searched the forum, and couldn't find an answer. So I apologize if this is out there. This seems simple in my mind, however, I can't seem to get the correct code.

I have 2 tables. STUDENT_TERMS_VIEW table holds the STTR_STUDENT, STTR_TERM and TERMS table, holds the TERM_END_DATE. I need to find a way to select the student's last term based on MAX(TERM_END_DATE), but I get STTR_TERM duplicate rows per student. I need to get 1 row per student and their last term attended.

thanx 

[View SQL Image][1]


  [1]: http://i.stack.imgur.com/vjGLQ.png