Hi I have two tables professor and exam. The professor table has: (id, year-name and degree) fields. The year table has : (year-name, start-date and end-date) fields. i want to know how i can select the professor degree who have the MAX start-date. Thank you!!