> "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 sysNam
"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 ea
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 >calc
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
