SQL - UNION ALL (two queries SELECT)

This is an example of UNION ALL for two queries SELECT sentences:



    SELECT T.filend1
      FROM  TABLE T
    WHERE T.field=1
    GROUP BY T.field1

UNION ALL

    SELECT TT.filend2
      FROM  TABLE TT
    WHERE TT.field=1
    GROUP BY TT.field1


Note: The senetence ORDER BY is not accepted in this example.