Select Query
select c.name, p.description 
from customer_t5 c join cust_prod_t5 cp on 
c.cust_no = cp.cust_no join product p on cp.prod_no = p.prod_no 
where p.description ='xxx';
// don't have purchased “CD DRIVE” then me used of "xxx" in description.

Output
NAME           DESCRIPTION
-------------- -------------
pratik           xxx
aman             xxx

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