Keith [EMAIL PROTECTED] wrote:
had to upgrade mySQL but I got the subquery working for individual entries.
Trouble now is that I can't figure out how to get it to work for more than
one entry. The query currently stands at:
SELECT SQL_CALC_FOUND_ROWS sys.sectorID, sys.name AS sysName,
Keith [EMAIL PROTECTED] wrote:
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
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
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