>How can I join the follwing to get a 1 record result set
>
>select 1 as a, 2 as b
>select 3 as c, 4 as d
>
>
>to end up with a resul set like
>
>a b c d
>- - - -
>1 2 3 4
>
>Paul
I am not sure if I understood You corectly but what about:
select 1 as a, 2 as b, 3 as c, 4 as d
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.