Skip to Content
0
Feb 17, 2011 at 04:27 PM

how to write equivalent of this query of ORACLE 10g in abap

44 Views

Here is my query which runs perfectly for ORACLE 10G. One of the tables used below EMPADV has multi record.

select emp1.empno,emp1.ename,emp1.sal,adv.totadv 
from  (select empno,ename,sal from emp) EMP1, 
(select empno,sum(adv) totadv from empadv group by empno) ADV 
where emp1.empno = adv.empno ;

Now i want to write exactly the same query in ABAP.

As you can see inside the FROM clause , there is a nested query (which is new feauture of 10g). Can i write the nested query in FROM clause in abap too.

I have tried this query using nested select.endselect statements too but i want to know if its possible to get the above output in a single statement (as shown above for oracle 10g).

THANKS