Select Query

select p.prod_no, cp.cust_no, c.name  
from product_t5 p, cust_prod_t5 cp,
customer_t5 c  where cp.cust_no=c.cust_no and p.prod_no=cp.prod_no;

Output

PROD_N CUST_N NAME
------ ------ ---------
0001   001    pratik
0002   002    aman
0003   003    dilkhush
0004   004    Ajay
0005   005    shiva

Leave a Reply

Subscribe to Posts | Subscribe to Comments

All Notes on BCA

All Notes  on BCA
BCA all subjects notes

Total Pageviews

Translate

Powered by Blogger.

Copyright © All Notes on BCA