Select Query
select sm.salesman_no, sm.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 sm on sm.salesman_no=o.salesman_no where sm.salesman_name='manish';Output
SALESM SALESMAN_NAME ORDER_ PRODUC QTY_ORDER ------ -------------- ------ ------ ---------- s00002 manish o00002 0002 2