Problemer med grou by

Prøv

select dato, (intrans+ inord+ proposal) as total
from vmi_prog
where cust = '00500'
group by dato
order by dato

Virker ikke helt
Det giver dette resultat:
Dato      total
2010-04-14 297
2010-04-16 440
2010-04-20 600
2010-04-21 594
2010-04-23 480
2010-04-27 0
2010-04-28 16
2010-04-29 297
2010-05-04 350


mine data se sådan ud og jeg vil så gerne
have en sum på intrans + inord + proposal
pr. dato

part    dato      intrans inord proposal
1891508 2010-04-14 0.00 297.00 0.00
2077345 2010-04-16 0.00 1848.00 0.00
1872866 2010-04-16 0.00 297.00 0.00
1721522 2010-04-16 0.00 594.00 0.00
1950151 2010-04-16 0.00 480.00 0.00
2077369 2010-04-16 0.00 1320.00 0.00
1929263 2010-04-16 0.00 2000.00 0.00
2084169 2010-04-16 0.00 38.00 0.00
1396034 2010-04-16 0.00 440.00 0.00
1393552 2010-04-16 0.00 440.00 0.00
1197525 2010-04-16 0.00 27.00 0.00
1194319 2010-04-16 0.00 440.00 0.00
2088549 2010-04-16 0.00 660.00 0.00
1960938 2010-04-16 0.00 960.00 0.00
2056784 2010-04-20 0.00 0.00 2000.00
2056845 2010-04-20 0.00 0.00 1900.00
2105864 2010-04-20 0.00 0.00 3300.00
2083629 2010-04-20 0.00 0.00 247.00
1929263 2010-04-20 0.00 0.00 8000.00
1406719 2010-04-20 0.00 0.00 600.00
1893175 2010-04-20 0.00 0.00 137.00
1674248 2010-04-20 0.00 0.00 4620.00
1873047 2010-04-20 0.00 0.00 356.00
1097764 2010-04-21 0.00 594.00 0.00
1950151 2010-04-21 0.00 480.00 0.00
1512984 2010-04-21 0.00 220.00 0.00
2077369 2010-04-21 0.00 1980.00 0.00
1108057 2010-04-23 0.00 480.00 0.00
1856835 2010-04-23 0.00 198.00 0.00
2056746 2010-04-23 0.00 660.00 0.00
1929263 2010-04-27 0.00 0.00 0.00
2056746 2010-04-28 0.00 1320.00 0.00
1900231 2010-04-28 0.00 16.00 0.00
2102887 2010-04-28 0.00 6000.00 0.00
1907162 2010-04-28 0.00 44.00 0.00
1889352 2010-04-29 0.00 297.00 0.00
2073903 2010-05-04 0.00 0.00 2850.00
1537086 2010-05-04 0.00 0.00 350.00

Det er jo også rigtigt:

select dato, sum(intrans)+ sum(inord)+ sum(proposal) as total
from vmi_prog
where cust = '00500'
group by dato
order by dato

ja så virker det, tak for det

kommer du med et svar, så er der point

Jeg samler slet ikke på point, tak. Svar selv, accepter dit eget svar.

så siger jeg tak