SQL Question
How do you do a select into variable with a union?
i.e.
I know
select id, desc
into var1, var2
from tab1But I do not know;
select id, desc
from tab1
union
select id2, desc2
from tab2;
Any help would be appreciated.
How do you do a select into variable with a union?
i.e.
I know
select id, desc
into var1, var2
from tab1But I do not know;
select id, desc
from tab1
union
select id2, desc2
from tab2;
Any help would be appreciated.