Select Query
select s.salesman_no, s.salesman_name, o.order_no, so.product_no,
so.qty_order from order_t5 o join sales_order_t5 so on
so.sales_order_no=o.order_no join sales_mans_t5 s on
s.salesman_no=o.salesman_no  where salesman_name='ravi';

Output
SALESM SALESMAN_NAME   ORDER_ PRODUC  QTY_ORDER
------ --------------- ------ ------ ----------
s00003 ravi            o00003 0003            2

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