Select Query
select c.name from customer_t5 c JOIN order_t5 o on
c.cust_no=o.client_no JOIN sales_order_t5 s
ON o.order_no = s.sales_order_no JOIN product_t5 p ON
s.product_no = p.prod_no where unit_price >=1000;

Output
NAME
----------
pratik
aman
dilkhush
Ajay

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