SELECT customer_id, purchase_value, Sale_value FROM Purchase FULL JOIN Sales ON Purchase.customer_id = Sales.customer_id
select (customer_id, purchase_value, Sale_value) into NewTable from Purchase inner join Sale on Purchase.customer_id = Sale.customer_id
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)