Create a view for producing mailing labels that merges toget

Create a view for producing mailing labels that merges together name and address fields from both the Customers table and from the SalesContacts table into a single virtual table. The query should remove any duplicate rows. Create a query (in Lab06.accdb) that selects all employee records from Lab05 accdb.

Solution

7)

using:

8)

select * from MailingLabel