Keith >i'm trying to find the max value of a certain field and return a field linked with the max value. The tables:
>planets-- >population >government >sysID >systems-- >sysID >For examples sake lets say we are searching through three sysID's. For each sysID I want to look in planets and >calculate the largest population value where the sysID's are the same then return the government value for the planet >with the largest population for each sysID. You mean ... SELECT government FROM planets WHERE population = (SELECT MAX(population) FROM planets); ? PB
