All Notes on BCA

select cp.cust_no,c.name, cp.prod_no, p.description  from 
customer_t5 c join cust_prod_t5 cp on c.cust_no=cp.cust_no
join product_t5 p on p.prod_no=cp.prod_no;

CUST_N NAME       PROD_N DESCRIPTION
------ ---------- --------- -----------
001    pratik     0001   xxx
002    aman       0002   xxx
003    dilkhush   0003   yyy
004    Ajay       0004   zzz
005    shiva      0005   aaa