SQL & PL/SQL

Hi,

I am running two independent queries giving two result tables resp, like below:

TARGET_NAME METRIC AVG(AVR) AVG(AVRMAX)
Server1 heapUsedPercentage.value 24.85833333 25.375
Server2 heapUsedPercentage.value 23.18125 23.625
Server3 heapUsedPercentage.value 51.29487179 53.35897436
Server4 heapUsedPercentage.value 38.63461538 39.61538462


and the other table is:


TARGET_NAME METRIC AVG(AVR) AVG(AVRMAX)
Server1 session.active 0.3 0.35
Server2 session.active 0.051282051 0.051282051
Server3 session.active 1.346153846 1.794871795
Server4 session.active 0 0


They both are querying the same table.
Here are the queries:


SELECT target_name,
metric_column metric,
AVG(avr),
AVG(avrmax)
FROM
(SELECT
target_name,
metric_column,
AVG(average) avr,
AVG(maximum) avrmax
FROM mgmt$metric_hourly
WHERE rollup_timestamp BETWEEN to_date(:FROMDATE) AND to_date(:endDATE)
AND TO_CHAR(rollup_timestamp+(13.5/24), 'HH24') BETWEEN '10' AND '17'
AND (metric_name = 'jvm' AND metric_column='heapUsedPercentage.value')
AND target_name IN
(SELECT target_name
FROM MGMT$GROUP_MEMBERS
WHERE GROUP_NAME LIKE 'Test Group'
AND target_type='weblogic_j2eeserver'
)
GROUP BY target_name,
metric_column
ORDER BY target_name,
metric_column
) mytab
GROUP BY target_name,
metric_column


and other query is similar:

SELECT target_name,
metric_column metric,
AVG(avr),
AVG(avrmax)
FROM
(SELECT
target_name,
metric_column,
AVG(average) avr,
AVG(maximum) avrmax
FROM mgmt$metric_hourly
WHERE rollup_timestamp BETWEEN to_date(:FROMDATE) AND to_date(:endDATE)
AND TO_CHAR(rollup_timestamp+(13.5/24), 'HH24') BETWEEN '10' AND '17'
AND (metric_name = 'server_overview'
AND metric_column='session.active')
AND target_name IN
(SELECT target_name
FROM MGMT$GROUP_MEMBERS
WHERE GROUP_NAME LIKE 'ST3B15 IC Domain Group'
AND target_type='weblogic_j2eeserver'
)
GROUP BY target_name,
metric_column
ORDER BY target_name,
metric_column
) mytab
GROUP BY target_name,
metric_column



I have to combine these above two queries to get the results in below manner in a single table by avoiding redundant columns.


TARGET_NAME AVG_SESSIONS MAX_SESSIONS AVG_HEAP MAX_HEAP
Server1 0.3 0.35 24.85833333 25.375
Server2 0.051282051 0.051282051 23.18125 23.625
Server3 1.346153846 1.794871795 51.29487179 53.35897436
Server4 0 0 38.63461538 39.61538462

Can somebody help?

Thanks.