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 [email protected] 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
