Table:ACCOUNT_SUMMARY

prod_id Cust_id

101       AAA
101       BBB
101       CCC
102       AAA
103       AAA
102       CCC


Table : Product

Prod_id Prod_desc
101       Home_loan
102       Vehicle loan
103       Educational Loan


Expected Output: 

Cust_id  Prod_desc
AAA      Home_loan
AAA      Vehicle loan
AAA      Educational Loan 

WITH T AS (
           SELECT  CUST_ID,
                   PROD_DESC,
                   COUNT(*) OVER(PARTITION BY A.CUST_ID) CNT1,
                   COUNT(A.PROD_ID) OVER(PARTITION BY A.CUST_ID) CNT2
             FROM      ACCOUNT_SUMMARY A
                        PARTITION BY(CUST_ID)
                   RIGHT JOIN
                       PRODUCT P
                     ON A.PROD_ID = P.PROD_ID
          )
SELECT  CUST_ID,
        PROD_DESC
  FROM  T
  WHERE CNT2 = CNT1
/