how to join one to many tables in oracle : I have four tables
Order, Employee, Supply, Supply_company

Order--- Contains
-—-------------
Order_id
Order name
Emp_id


Employee--- Contains
------------------
Emp_id
Emp_name

Supply ----- Contains
--------------------
Supply_id
Order_id
SupplierName

Supply_company-----Contains
----------------------
Supply_company_id
Supply_id
Supplier_desc
address

In these 4 tables one employee has more than one order and One order has many supply id's and for that one supply id we have one supplier desc. I wanted to display supplier_desc based on emp id. I am getting all the descriptions assosciated for all orders but I need to get specific desc for specific order,I have tried distinct, listagg, inner join and left outer join and used subquery in where clause but I didn't fina any solution. Any solution will be appreciatable.Thanks