how to simulate a UNION?

[Michael Geary]

Hi Folks,

I've got 2 tables with similar data. The tables are NOT related, so my 
objectives cannot be achieved with a JOIN. Ideally, I could do a UNION 
like this:

(
SELECT
table1.description,
table1.id

WHERE
table1.description LIKE 'blah'
)
UNION ALL
(
SELECT
table2.description,
table2.id

WHERE
table2.description LIKE 'blah'
)

order by
description asc
----------------

But, I can't do this in Valentina. So, I have to find a workaround. One 
problem is that I need to sort the results of both tables together, so 
if I simply do two queries, I have to do a lot of manual work to sort 
the results. I saw a reference in the List Archive at one point to a 
Temporary Table, but I can't find any more info on that. It sounds like 
that would be my best approach, but I can't see anything in the docs.

I'd appreciate any pointers.

Thanks,

michael