SELECT * FROM csrOpenSum ; UNION ; SELECT * FROM csrInvoiceSum ; INTO CURSOR crsTemp1 SELECT * FROM crsTemp1 ; UNION ; SELECT * FROM csrTransferInSum ; UNION ; SELECT * FROM csrTransferOutSum ; UNION ; SELECT * FROM csrHisRunOutSum ; UNION ; SELECT * FROM csrLogFileLPSum ; UNION ; SELECT * FROM csrAdjAddSum ; UNION ; SELECT * FROM csrAdjMinusSum ; UNION ; SELECT * FROM csrSalesSum ; UNION ; SELECT * FROM csrReturnSum ; UNION ; SELECT * FROM csrCNSum ; INTO CURSOR csrTotalSum