From the course: Access 2019: Queries
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create a union query to join tables
From the course: Access 2019: Queries
Create a union query to join tables
- [Instructor] The union query is a special type of query within Access. And it's used to combine the results of two or more queries into one record set. In order to accomplish this task though, we need to make use of the SQL editor. The union query simply cannot be constructed in the design view. Let's suppose that I wanted a combined email list for both customers and employees. Let's first take a look at the data in the customers table. We have the first name field, last name, and let's scroll over here to the right, we have the email field. In the employees table, I also have a first name field, last name, and an email field. Let's go ahead and combine these into a single list. I'm going to start the process by going into the create tab and clicking on query design. Then I'll go ahead and add in the customers table. I'll close the show table window and up here in the query type button you'll notice that we do have a button called union. If I go ahead and click that though, it just…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.