SELECT with many SUMs
Posted: Wed Nov 30, 2005 2:07 am
Hai i need a SELECT like this:
Its working like this
and like this:
BUT not like the first - - - so any suggestions???
Code: Select all
SELECT SUM(contramount) 'Bekommen' FROM sam_date_val WHERE projnr BETWEEN '1000' AND '5000'; SUM(tovalue) 'Genommen' FROM sam_date_valCode: Select all
SELECT SUM(contramount) 'Bekommen' FROM sam_date_val WHERE projnr BETWEEN '1000' AND '5000'; SUM(tovalue) 'Genommen' FROM sam_date_valCode: Select all
SELECT SUM(contramount) 'Bekommen',SUM(tovalue) 'Genommen' FROM sam_date_val