Select Query
select c.cust_no,so.product_no,so.sales_order_no,so.qty_order  
from order_t5 ot join sales_order_t5 so on ot.order_no=so.s_order_no
join customer_t5 c on c.cust_no=o.client_no join product_t5 p on 
p.product_no=so.product_no where so.qty_order<5 and p.description='xxx';

Output
no rows selected

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