INNER JOIN

SELECT Company.Name, Company.Address, Orders.OrderNo
FROM Company
INNER JOIN Orders
ON Company.C_Id=Orders.C_Id
ORDER BY Company.Name