SELECT DISTINCT stationno, ; (SELECT sum(mt1.colamt1) FROM mytable mt1 JOIN mt ON mt.stationno = mt1.stationno WHERE tranno=1) AS colamt1, ; ...; from mytable mt ; INTO CURSOR tmp NOFILTER>Thank you Sergey.
SELECT stationno, ; >> sum(IIF(tranno=1,colamt1, 0000000.00)) AS colamt1, ; >> sum(IIF(tranno=2,colamt2, 0000000.00)) AS colamt2 ; >>from mytable ; >>GROUP BY stationno ; >>INTO CURSOR tmp NOFILTER >>