/*  *************************************  */

SELECT COUNT(A_C1) INTO A FROM A
WHERE A_C1 IN

(SELECT DISTINCT B_C1 FROM B WHERE LTRIM(RTRIM(DRGNNO_REF)) = LTRIM(RTRIM(B_C2)))

AND (A_C2,A_C3,A_C4,A_C5) IN (SELECT A_C2,A_C3,A_C4,A_C5 FROM A
HAVING COUNT(A_C2) > 1
AND
COUNT(A_C3) > 1
AND
COUNT(A_C4) > 1
AND
COUNT(A_C5) > 1
AND
A_C5 <> 'NA'
GROUP BY A_C2,A_C3,A_C4,A_C5);

/*  *************************************  */