Thanks a lot .

select a.a, a.b, b.c
FROM (select p a ,count(1) b FROM TEST1 GROUP BY P) a,
(select p1,COUNT(1) c FROM TEST2 GROUP BY P1) b
where a.a = b.p1(+)
/

A B C
----- ---------- ----------
1 3 4
2 2


The answer has come but if we use the select in a select will it decrease the performance ?

Regards
Shyla