You intend to join a Customer master file (Customer) to a Sa…
You intend to join a Customer master file (Customer) to a Sales transaction file (Sales) and have all records and fields from Table A included as well as any sales from Table that correspond to the customers. Complete the following SQL statements to obtain this output: SELECT * FROM Customer _________________ Sales ON Customer.CustomerID=Sales.CustomerID;