From: Adam Flinton 

John Beamish wrote:
> SELECT *
> FROM [select f1 from table1 union select f2 from table2]. AS mystuff;
>

Followed by an order statement wrapping that.

Adam

> "Adam Flinton"  wrote in message
> news:3ebb74d1{at}w3.nls.net...
>
>>Why didn't union/union all followed by an orderby statement work?
>>
>>I'm sure access has union/union all & order by (nb last used Access:
>>version = 97 in about 1999/2k)
>>
>>Union is for doing just what you've set out below.
>>

--- BBBS/NT v4.01 Flag-4