SELECT *,;
>	SUM(IIF(Mode="B",BAGS,0)) AS B1,;
>	SUM(IIF(Mode="L",BAGS,0)) AS L1;
>---->	FROM AVLBOOK;
>	ORDER BY ACC_NO;
>	GROUP BY ACC_NO;
>	INTO CURSOR XYZ