If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL ...

As one composes SQL Select statements, the author may use another query in place of any table or view. Even individual columns may be replaced with queries of varying complexity—if the result fits in ...

select into union should work fine.<BR><BR>put the into on the first select<BR><BR>select into blah from where union select from where<BR><BR>Ive done this on archaic sybase ase (ooold version) so ...