>SELECT s.Date AS DateFld, SUM(S.Count) AS SumNum ; > FROM SAMPLE S ; > INTO CURSOR Three ; >UNION ALL (SELECT E.Date AS DateFld, E.Number AS SumNum ; > FROM Example E ) >>
SELECT s.Date AS DateFld, SUM(S.Count) AS SumNum ; FROM SAMPLE S ; UNION ALL (SELECT E.Date AS DateFld, E.Number AS SumNum ; FROM Example E ) ; GROUP BY whatever ; && optional ORDER By whatever ; && optional INTO CURSOR Three ;All INTO, GROUP BY, and ORDER clauses go at the end of the SQL command.