From the course: Access 2021: Queries

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Create a union query to join tables

Create a union query to join tables

From the course: Access 2021: Queries

Start my 1-month free trial Buy for my team

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'll need to use the SQL editor. The union query simply cannot be constructed in the design view. Let's take a look at the data that I have stored it in the customer's table. And you'll see that we have columns for the customer's first name, last name, and email address. If I open up the employee's table, you'll see that we have similar columns, first name, last name, and their email address. If I wanted to create a query that combines all of the names and email addresses from both of these tables I can do that with a union query. Let's close both of these tables and we'll get started by creating a new query in design view. Now I'm going to get started creating that query here in design view, but then we'll have to switch into…

Contents