Select Query
SELECT Distinct c.name, p.description, s.Qty_Order 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 name ='pratik';
NAME DESCRIPTION QTY_ORDER ---------- ------------- ---------- pratik xxx 4