special table output!!!
Posted: Wed Nov 23, 2005 11:44 pm
Hai
i want to build a table output that is ordered like this:
http://rzserv2.fhnon.de/~lg016500/untitled1.bmp
(the <10, <100 etc is just an example - i want it to be seperatet by different dates)
I want to fill out the blanks, but i dont know how i have to do the SELECTs.
It could be done like this:
But i just get one output that i want. I just get one output, but i want to have a new collum with the second date select. Is it possible to make a SELECT for every row???
joe
i want to build a table output that is ordered like this:
http://rzserv2.fhnon.de/~lg016500/untitled1.bmp
(the <10, <100 etc is just an example - i want it to be seperatet by different dates)
I want to fill out the blanks, but i dont know how i have to do the SELECTs.
It could be done like this:
Code: Select all
SELECT sum(tovalue) from sam_date_val group by actdeldate BETWEEN DATE '2003-01-01' AND DATE '2005-08-08' AND actdeldate BETWEEN DATE '2005-09-09'AND DATE '2015-08-08'joe