RE: [nl-users] BASE Query sorteren groeperen sommeren

Wat ook zal werken:

SELECT "Kostenplaats", SUM( "Bedrag" ), "Naam", "Boeking" 
FROM "ASNDPK" 
GROUP BY "Kostenplaats", "Naam", "Boeking" 
ORDER BY "Kostenplaats" ASC, "Naam" ASC, "Boeking" ASC

Winfried

> Ik denk dat het probleem hier in zit:
>
> When a |<group by clause>| is used, only the columns used in the |<group
> by clause>| or expressions used there, can be used in the |<select
> list>|, together with any |<aggregate function>| on other columns. In
> other words, the column names or expressions listed in the GROUP BY cluase
> dictate what can be used in the |<select list>|. After the rows of the
> table formed by the |<from clause>| and the |<where clause>| are
> finalised, the grouping operation groups together the rows that have the
> same values in the columns of the |<group by clause>|. Then any
> |<aggregate function>| in the |<select list>| is performed on each
> group, and for each group, a row is formed that contains the values of the
> columns of the |<group by clause>| and the values returned from each
> |<aggregate function>|.
>
> > SELECT "Kostenplaats", "YYYY-MM-DD", SUM( "Bedrag" ), "Naam",
> > "Boeking" FROM "ASNDPK" GROUP BY "Kostenplaats" ORDER BY
> > "Kostenplaats" ASC, "YYYY-MM-DD" ASC
> >
> > Hier heeft Base een probleem mee...

-- 
Unsubscribe instructions: E-mail to users+unsubscribe@nl.libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/nl/users/
All messages sent to this list will be publicly archived and cannot be deleted