This question already has answers here: Get top 1 row of each group (19 answers) Closed 4 days ago. I have two tables as follows: Table A : contacts Contact_Primary_Num Displayed_Name 1 Smith, Joe 2 Doe, Donna 3 Jerry, Tom 4 Crocker, Betty Table B : contact_notes Contact_Note_Primary_Num Contact_Num Contact_Note_Date Contact_Follow_Up_Date 1 2 2024-06-19 2024-06-24 […]