Select Query
SELECT p.description, o.order_no, c.cust_no, c.name 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 description='xxx';
DESCRIPTION ORDER_ CUST_N NAME ------------ ------ ------ -------- xxx o00001 001 pratik xxx o00002 002 aman