SQL Subqueries
Subject:   Subqueries
Date:   2004-01-29 22:43:01
From:   wildmaniac2004
High, im trying to work on a transfrom query that includes or calls a subquery. I am supposed to generate a recordset that provides a summary of donation money received by alumni graduation year. That is not hard, however i am getting stuck when it then states that for alumni that have more than one degree i should take the lastest graduation date. Note that the infromation im using is coming from two tables that are linked by the StudentID field. One has the donation information for each student and the other has the graduation dates for each. Please let me know if there is anyway i can retreive records with the latest graduation date.