Hariharan Sukumar
New User
Joined: 14 Mar 2011 Posts: 14 Location: India
|
|
|
|
Thanks yaar,
I got the exact result as i expected...
I used full outer join and got the thing ...
SELECT * FROM
(SELECT STS AS R_STS,COUNT(*) AS R_CNT
FROM TAB_R
WHERE R_DATE = CURRENT DATE
GROUP BY STS)R
FULL OUTER JOIN
(SELECT STS AS I_STS,COUNT(*) AS I_CNT
FROM TAB_I
WHERE I_DATE = CURRENT DATE
GROUP BY STS)I
ON R.R_STS = I.I_STS
WITH UR;
OUTPUT:
-----------
R_STS R_CNT I_STS I_CNT
---- ----------- ---- -----------
AWST 1 - -
CANC 1 CANC 1
- - RECV 6
- - REJD 16
SETT 108739 SETT 108625
THANKS FOR TELLING THE KEYWORD FULL OUTER JOIN ..NOW I'M CLEAR .... |
|