|Subject||query to return the last entry in detail table for each entry in master table|
I have an assignment table (master table) and a review table (detail table). The review table holds one or more records for each record in the assignment table. I need a query to return the latest review for each record in the assignment table. Could someone advise me on a query to do this.
The assignment table has the following fields: assignid, assign_date, manager, Projectid
The review table has the following fields: reviewid, assignid, review_date, progress_note
Thanks in advance.