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.
