Re: Help!!!

[Claude Martin]

> GROUP BY date.id, pump1.TVater1
why do you group by TVater1?!
group by some id!

> i resive the replay
>
> id TVater1 PAir1
> 5 20 30

i bet you do! thats what the GROUP BY is supposed to do. it groups...

> bat there`s only 1 record, not 5
>
> and i wont to get 5 of them
use this GROUP BY to get 5 results:
GROUP BY date.id, `pump1`.owner

but remember that mysql takes the first puymp1.TVater1 it gets but you can use the group functions:
http://dev.mysql.com/doc/mysql/en/group-by-functions.html

http://animalliberation.tk http://veganismus.ch
http://maqi.de http://tierrechtskochbuch.de