how to simulate a UNION?

[Michael Geary]

Thanks for the reply, Ruslan.

One more question:

Is there an actual Temporary table type that gets cleaned up? Or do I 
have to manually create a normal table? What if the database is 
read-only?

When I search the V4MD docs, I get zero relevant hits for the word 
"temporary"...?

> In any UNION will require from DBMS to build TMP table.
>
> So you can do this self.
> Make TMP table, then do
>     SELECT INSERT INTO
> For first table.
>
> Then
>     SELECT INSERT INTO
> For second table.
>
> In both cases INSERT into the same TMP Table.
> Then you can try sort it...
> Not very nice...
>

---------------------------------------------------------
michael geary
The Treeline Group, Inc., makers of PTeval
560 S. State Street, E-2
Orem, UT 84058

(801) 225-1414 x 1002
http://www.treelinegroup.com
http://www.pteval.com