{section}{column:width=50%}

SELECT A.CD,AT,QT
FROM(SELECTCD,SUM(AT) AT
     FROM TAB7GROUPBYCD) A, TAB8 B
WHERE A.CD=B.CD;

{column}{column:width=50%}

Execution Plan 
-------------- 
Plan hash value: 2364579534 
----------------------------------------------------------------------------- 
| Id | Operation         | Name | Rows | Bytes | Cost (%CPU)| Time     |
-----------------------------------------------------------------------------
| 0  |SELECTSTATEMENT    |      | 9    | 360   | 8 (25)     | 00:00:01 | 
|* 1 | HASH JOIN         |      | 9    | 360   | 8 (25)     | 00:00:01 | 
| 2  | TABLE ACCESS FULL | TAB8 | 4    | 80    | 3 (0)      | 00:00:01 | 
| 3  | VIEW              |      | 9    | 180   | 4 (25)     | 00:00:01 | 
| 4  | HASHGROUPBY       |      | 9    | 180   | 4 (25)     | 00:00:01 | 
| 5  | TABLE ACCESS FULL | TAB7 | 9    | 180   | 3 (0)      | 00:00:01 | 
----------------------------------------------------------------------------- 
Predicate Information (identifiedbyoperation id):
--------------------------------------------------- 
1 - access("A"."CD"="B"."CD")

{column}{section}