g'day, 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. Cheers, Keith