RIGHT JOIN

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