CREATE CURSOR crsKeys (fixkey C(4)) INSERT INTO crsKeys VALUES("key1") INSERT INTO crsKeys VALUES("key2") INSERT INTO crsKeys VALUES("key3") SELECT key, sum(valuea), sum(valueb) ; FROM crsKey ; LEFT JOIN mytable ON fixkey = key ; WHERE date BETWEEN startdate AND enddate ; ORDER BY key ; INTO ARRAY arr>I have a Select command similar to the following
> SELECT key, valuea, sun(valueb) from table > order by key > where between(date,startdate,enddate) > into array a >>My problem is that I can get 1 to 3 rows in the array depending on the data. What I want is to always get 3 rows with zero for non-existant values. For example assume only key2 has a data. I then want the result like
> key1 0 > key2 12 > key3 0 >>What is the best way of doing this?