[RESOLVED] Get the max value of two different data in two different tables

[jmcilhinney]

So, every ID in table 2 will appear in table 1, and every ID will always have the same name in both tables?