select *
from Customers full outer join Orders on Customers.CustomerID = Orders.CustomerID