with rollup

When I use "With rollup," I am getting totals on columns which are numeric,
however, non-numeric columns are copying down to the rollup column (i.e. the
last column's non-numeric columns are being duplicated on the rollup
column).

For example. if I order by date with rollup and, I am also outputting
emplyee, and some numeric value , at the rollup row, the totals appear, that
date, of course, properly appears, but the employee name from the previous
row is also duplicated on this row.

How can I avoid that? Thanks, Ike
Ike [ Fr, 15 September 2006 14:56 ] [ ID #1467398 ]
Datenbanken » mailing.database.mysql » with rollup

Vorheriges Thema: getting the key of an inserted record
Nächstes Thema: Can anyone help a newbie figure out MySQL?