SELECT...INTO and UNION query

I am having trouble with the fillowing type of statement

select E, B, C
into var1, var2, var3
from

(select A as E, B,C

    from .....
    where....
    union all
    select D as E, B,C
    from .....
    where....);

For some reason var1 is being set to null but var2 and var3 are getting the correct values.

It works if I use the following query but I would prefer not to do this:

select *
into var1, var2, var3
from

(select A, B,C

    from .....
    where....
    union all
    select D, B,C
    from .....
    where....);

Any help would be appreciated,

Thanks
Mike Received on Wed Jul 28 1999 - 14:30:17 CDT