select *
from Customers left join Orders on Customers.CustomerID = Orders.CustomerID