union
i have a 2 sql statements with a union.
ex:
select sum(salary) as salary from dept
where dept_id=30
union
select sum(salary) as salary from dept
where dept_id=10
this query would show something like this:
salary
--------
20000
35000
I need the salary to display something like:
salary1 salary2
------------------------
20000 35000
Is this possible?
Thanks for having a look at this!