select *
from Customers c left merge join Orders o on c.CustomerID = o.CustomerID