Union in Axapta Queries (Dynamics AX)

I am used to using the UNION in SQL Queries but I could not find this feature in Axapta Select or Queries.

Then i came to know that UNION and CASE is not supported by AX selects or queries:

For Union a workaround is the loop all records and insert them into a temporary table or a RecordSortedList.

You might have to use the WHERE clause instead

Wait for these features to be incorporated in AX queries or Selects.

:)