Find the products and their quantities for the orders placed by client number “C00001” and “C00002”.
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';
SALESM SALESMAN_NAME ORDER_ PRODUC QTY_ORDER ------ --------------- ------ ------ ---------- s00003 ravi o00003 0003 2