
Slecting the maximum value of a group of records
Question: Let’s say I have a table (table1) with 100 unique ID numbers, each belonging to one of five categories. On another table (table2) I have a whole lot of info for each of these ID numbers. Table2 may have more than one record for each of the ID numbers?each