SELECT
	0 as orderkey,
	history.mtype as mtype,
	history.clientid as clientid,
	ClientInfo.Firstname as firstname,
	ClientInfo.LastName as lastname,
	history.amount as amount,
	history.description as description,
	history.datereceived as datereceived
FROM history JOIN ClientInfo
ON history.clientid = clientinfo.clientid
UNION
SELECT * FROM (SELECT
	1 as orderkey,
	null as mtype,
	null as clientid,
	null as firstname,
	null as lastname,
	SUM(history.amount) as amount,
	'total' as description,
	history.datereceived as datereceived
FROM history JOIN ClientInfo
ON history.clientid = clientinfo.clientid
GROUP BY history.datereceived)
ORDER BY daterecieved,orderkey

--lokkju