不知道解没解决,你可以这样: SELECT dbecode AS name, dbecode AS b, dbdate AS a, dbjobnumber AS c, dbworkid AS d, dbworktime AS e, dbattribute AS f, memo AS g into temp1 FROM tbreport UNION ALL SELECT dbecode AS name, '12' AS b,'1900-01-01' AS a, '13' AS c, '14' AS d, SUM(dbworktime) AS e, '15' AS f, 'g' AS g FROM tbreport GROUP BY dbecode UNION ALL SELECT '22' as name, '20' AS b, '1900-01-01' AS a,'23' AS c, '24' AS d, SUM( dbworktime) AS e, '25' AS f, 'g' AS g FROM tbreport ORDER BY name,a desc
SELECT dbecode AS name, dbecode AS b, dbdate AS a, dbjobnumber AS c,
dbworkid AS d, dbworktime AS e, dbattribute AS f, memo AS g into temp1
FROM tbreport
UNION ALL
SELECT dbecode AS name, '12' AS b,'1900-01-01' AS a, '13' AS c, '14' AS d,
SUM(dbworktime) AS e, '15' AS f, 'g' AS g
FROM tbreport
GROUP BY dbecode
UNION ALL
SELECT '22' as name, '20' AS b, '1900-01-01' AS a,'23' AS c, '24' AS d,
SUM( dbworktime) AS e, '25' AS f, 'g' AS g FROM tbreport ORDER BY name,a desc