🚀 go-pugleaf

You cannot include a non-grouped field in a SELECT-claus when you dont
put it inside min(), max() etc. (i.e. aggregate functions).
The DBMS can't which ID it should take - there are several ones, since
it's grouped.

Roland


Dan Matthews schrieb:
> 
> Hi.
> Could someone do me a favour and tell me what is wong with the query below.
> When I try and run it, it complains abou the ID field not being part of an
> aggregate function.
> 
> Select a.name as Team, b.total - a.penalty as TeamTotal
> from
> (select v.name as name ,v.penalty as penalty ,v.id as id from VF1Team as v)
> as a,
> (select v1.name as name , sum(r.points) AS total , v1.id as id from VF1Team
> as v1 ,TeamPicks as t ,Driver as d ,RaceResults as r where v1.id = t.teamid
> and t.driverid = d.id and d.id = r.driverid group by v1.name) as b
> where a.id = b.id
> order by TeamTotal
> DESC;