From the course: Access 2016: Queries

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create a union query to join tables

Create a union query to join tables

From the course: Access 2016: Queries

Start my 1-month free trial

Create a union query to join tables

“

- [Voiceover] 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 a record set. In order to accomplish this task though, we need to make use of the SQL Editor. The Union Query simply can not be constructed in the Design View. Now before we start with our Union Query, we need to make sure that we know the themes of the fields for our tables. In this case, I wanna create a combined master email list that includes all of the emails from both my Customers Table, and the Employees Table. If I take a look inside of the Customers Table, we'll see that we have the column's first name, last name, and way over here on the far right, the E name email. If I take a look at the Employees Table, I have the same names, first name, last name, and way over here, we have email. Let's go ahead and close this down and start our Union Query. I'm gonna go to the Create tab, and we'll go into Query Design. First, I'm gonna add in my…

Contents