# 178|SQL – Unions with Precision

**URL:** <https://www.techhub.training/t/178-sql-unions-with-precision/2647>\
**Category:** Challenges\
**Tags:** sql, union, intro\
**Created:** [April 30, 2024, 7:48pm UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647 "2024-04-30T19:48:27Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Marta\_Ellsworth](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/marta_ellsworth/32/5512_2.png) [@Marta\_Ellsworth](https://www.techhub.training/u/Marta_Ellsworth)\
**Post date:** [April 30, 2024, 7:48pm UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/1 "2024-04-30T19:48:27Z")

</div>

_BYU Student Author_: @Marta_Ellsworth  
_Reviewers_: @Andrew_Wilson, @Sterling_Lane  
_Estimated Time to Solve:_ 25 Minutes

This is an intro challenge that is part of the [SQL Learning Path](https://www.techhub.training/t/sql-learning-path/2630).

We provide the solution to this challenge using:

- SQL

Need a program? Click [here](https://www.techhub.training/t/information-about-software-used-on-techhub-training/138).

**Overview**  
You’ve just started your new job as an accounting clerk at Precision Plane Parts (PPP). Your boss has discovered that you learned SQL in your intro to Information Systems class, and now he has a few tasks for you. Quickly write the SQL queries he has requested to make a good impression on your new boss!

**Instructions**

1. Your boss wants to send everyone a Christmas card. Create a list of the first name, last name, and email of all the vendors and employees at PPP.  
a. Select the “first\_name”, “last\_name”, and “employee\_email” fields from the “Employee” table.  
b. Since the email field on the vendor table is also titled email change the field “employee\_email” to “email”.  
c. Select the “first\_name”, “last\_name”, and “email” fields from the “Vendor” table.  
d. Union the two queries together.
2. The purchasing department is thinking about selling a few new items, they have included the table in the database, it is called “New\_Inventory”. Union this with the “Inventory” data.
3. Generate a list for this month’s employee raffle. This month, each employee gets one guaranteed entry. Additionally, each employee who either created or reviewed at least one order gets another entry.  
a. Select the “emp\_reviewer\_id” from the “Orders” table. Make sure to rename the column to “employee\_id” and only include each “emp\_reviewer\_id” once by using SELECT DISTINCT.  
b. Do the same as above for the “emp\_order\_creation\_id”.  
c. Select the “employee\_id” from the “Employee” table. Note that each employee is included only once in this table by default so there’s no need to select a distinct employee ID here.  
d. Union these three queries together, but make sure to do it in a way that the duplicates will not be removed since an employee may have multiple raffle entries.

 ![Challenge176_Image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/8ba8e766cd1c81b166be7820cf828dc6c1d12d26.png)

**Data Files**

- [Challenge178\_Data.accdb](https://byu.box.com/shared/static/2gnjjrwqescjs6e0yl6mp94xce0uf8sk)

> **Suggestions and Hints**
>
> - To change the name of a column in the output use AS (employee\_email AS email).
> - Remember that “Union” removes duplicates while “Union All” does not.

**Solution**

> **Solution Code**
>
> Query 1
> 
> ```auto
> SELECT first_name, last_name, employee_email AS email 
> FROM Employee 
> UNION SELECT first_name, last_name, email 
> FROM Vendor; 
> 
> ```
> 
> Query 2
> 
> ```auto
> SELECT * FROM Inventory 
> UNION  
> SELECT * FROM New_Inventory; 
> 
> ```
> 
> Query 3
> 
> ```auto
> SELECT DISTINCT emp_reviewer_id AS employee_id  
> FROM Orders 
> UNION ALL  
> SELECT employee_id  
> FROM Employee 
> UNION ALL  
> SELECT DISTINCT emp_order_creation_id AS employee_id 
> FROM Orders; 
> 
> ```

[Challenge178\_Solution.accdb](https://byu.box.com/shared/static/m7097bsz1sf44abeatdc2pbwd96rcflo)  
_Solution Video:_ [Challenge 178|SQL – Unions with Precision](https://youtu.be/vHJ0a4xRN48)

---

<div class="post-metadata">

**Author:** ![Gabrielle\_Johnson](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/gabrielle_johnson/32/7371_2.png) [@Gabrielle\_Johnson](https://www.techhub.training/u/Gabrielle_Johnson)\
**Post date:** [February 20, 2025, 8:04pm UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/2 "2025-02-20T20:04:15Z")

</div>

Time to Complete: 10 minutes  
Difficulty: Easy  
Solution: See Below  
1:  
SELECT first\_name, last\_name, employee\_email AS email  
FROM Employee  
UNION  
SELECT first\_name, last\_name, email  
FROM Vendor;  
2:  
SELECT \*  
FROM New\_Inventory  
UNION  
SELECT \*  
FROM Inventory;  
3:  
SELECT DISTINCT emp\_reviewer\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT DISTINCT emp\_order\_creation\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT employee\_id  
FROM Employee;

---

<div class="post-metadata">

**Author:** ![Porter\_Rich](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/porter_rich/32/7372_2.png) [@Porter\_Rich](https://www.techhub.training/u/Porter_Rich)\
**Post date:** [February 20, 2025, 8:55pm UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/3 "2025-02-20T20:55:15Z")

</div>

Time to Complete: 10 Mins  
Rating: Beginner  
Solutions:

1. SELECT first\_name, last\_name, employee\_email AS “email”  
FROM Employee  
UNION  
SELECT first\_name, last\_name, email  
FROM Vendor;

2. SELECT \*  
FROM New\_Inventory  
UNION  
SELECT \*  
FROM Inventory;

3.SELECT DISTINCT emp\_reviewer\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT DISTINCT emp\_order\_creation\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT employee\_id  
FROM Employee;

---

<div class="post-metadata">

**Author:** ![Meadow\_Mitchell](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/meadow_mitchell/32/7366_2.png) [@Meadow\_Mitchell](https://www.techhub.training/u/Meadow_Mitchell)\
**Post date:** [February 20, 2025, 9:27pm UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/4 "2025-02-20T21:27:13Z")

</div>

Time to complete: 7 minutes  
Difficulty: Beginner  
Notes: Enjoyed the challenge!

1. SELECT first\_name, last\_name, employee\_email AS email FROM Employee  
UNION  
SELECT first\_name, last\_name, email FROM Vendor;
2. SELECT \* FROM New\_Inventory  
UNION  
SELECT \* FROM Inventory;
3. SELECT DISTINCT emp\_reviewer\_id AS employee\_id FROM Orders  
UNION ALL  
SELECT DISTINCT emp\_order\_creation\_id AS employee\_id FROM Orders  
UNION ALL  
SELECT employee\_id FROM Employee;

---

<div class="post-metadata">

**Author:** ![Madelyn\_Boulton](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/madelyn_boulton/32/7288_2.png) [@Madelyn\_Boulton](https://www.techhub.training/u/Madelyn_Boulton)\
**Post date:** [February 20, 2025, 11:15pm UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/5 "2025-02-20T23:15:15Z")

</div>

Time to Complete: 10 minutes  
Difficulty: Easy  
Solution:

1. SELECT first\_name, last\_name, employee\_email AS email  
FROM Employee  
UNION  
SELECT first\_name, last\_name, email  
FROM Vendor;
2. SELECT inventory\_name  
FROM Inventory  
UNION  
SELECT inventory\_name  
FROM New\_Inventory;
3. SELECT DISTINCT emp\_reviewer\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT DISTINCT emp\_order\_creation\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT employee\_id  
FROM Employee;

---

<div class="post-metadata">

**Author:** ![ShortyoShire](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/shortyoshire/32/7289_2.png) [@ShortyoShire](https://www.techhub.training/u/ShortyoShire)\
**Post date:** [February 21, 2025, 2:36am UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/6 "2025-02-21T02:36:14Z")

</div>

Time to Complete: 13 minutes  
Difficulty: Easy  
Comments: None  
Solution:  
1:SELECT first\_name, last\_name, employee\_email AS email  
FROM Employee  
UNION  
SELECT first\_name, last\_name, email  
FROM Vendor;  
2:SELECT \*  
FROM Inventory  
UNION  
SELECT \*  
FROM New\_Inventory;  
3:SELECT DISTINCT emp\_reviewer\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT DISTINCT emp\_order\_creation\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT employee\_id  
FROM Employee;

---

<div class="post-metadata">

**Author:** ![Kathryn\_Thompson\_Whi](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/kathryn_thompson_whi/32/7373_2.png) [@Kathryn\_Thompson\_Whi](https://www.techhub.training/u/Kathryn_Thompson_Whi)\
**Post date:** [February 21, 2025, 6:02pm UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/7 "2025-02-21T18:02:42Z")

</div>

Time: 8 mins  
Difficulty: Easy  
Solution:  
1.  
SELECT first\_name, last\_name, employee\_email AS email  
FROM Employee  
UNION  
SELECT first\_name, last\_name, email  
FROM Vendor  
2.  
SELECT \*  
FROM New\_Inventory  
UNION  
SELECT \*  
FROM Inventory  
3.  
SELECT DISTINCT emp\_reviewer\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT emp\_order\_creation\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT employee\_id  
FROM Employee

---

<div class="post-metadata">

**Author:** ![Miles\_Maynes](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/miles_maynes/32/7377_2.png) [@Miles\_Maynes](https://www.techhub.training/u/Miles_Maynes)\
**Post date:** [February 22, 2025, 3:54pm UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/8 "2025-02-22T15:54:12Z")

</div>

Time to Complete: 10 Minutes  
Difficulty: EASY  
Solution:  
1.SELECT first\_name, last\_name, employee\_email AS email  
FROM [Employee]  
Union  
SELECT first\_name, last\_name, email  
FROM [Vendor]  
2.SELECT \*  
FROM [New\_Inventory]  
UNION SELECT \*  
FROM [Inventory];  
3.SELECT DISTINCT emp\_reviewer\_id AS emp\_id  
FROM [Orders]  
UNION ALL  
SELECT DISTINCT emp\_order\_creation\_id AS emp\_id  
FROM [Orders]  
UNION ALL  
SELECT employee\_id AS emp\_id  
FROM [Employee]

---

<div class="post-metadata">

**Author:** ![Emily\_Cook](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/emily_cook/32/7379_2.png) [@Emily\_Cook](https://www.techhub.training/u/Emily_Cook)\
**Post date:** [February 22, 2025, 5:08pm UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/9 "2025-02-22T17:08:07Z")

</div>

Time to Complete: 10 minutes  
Difficulty: Easy  
Solution:

1. SELECT e.first\_name, e.last\_name, e.employee\_email AS email  
FROM Employee e  
UNION  
SELECT v.first\_name, v.last\_name, v.email  
FROM Vendor v;
2. SELECT \*  
FROM Inventory  
UNION  
SELECT \*  
FROM New\_Inventory;
3. SELECT DISTINCT emp\_reviewer\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT DISTINCT emp\_order\_creation\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT employee\_id  
FROM Employee;

---

<div class="post-metadata">

**Author:** ![Joshua\_Anderson](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/joshua_anderson/32/7380_2.png) [@Joshua\_Anderson](https://www.techhub.training/u/Joshua_Anderson)\
**Post date:** [February 22, 2025, 5:25pm UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/10 "2025-02-22T17:25:04Z")

</div>

Time to Complete: 10 Minutes  
Difficulty: Beginner  
Q1)  
SELECT first\_name, last\_name, employee\_email AS email  
FROM Employee  
UNION  
SELECT first\_name, last\_name, email  
FROM Vendor;

1. 

SELECT \*  
FROM Inventory  
UNION  
SELECT \*  
FROM New\_Inventory

1. 

SELECT DISTINCT emp\_reviewer\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT DISTINCT emp\_order\_creation\_id AS employee\_id  
FROM ORDERS  
UNION ALL  
SELECT employee\_id  
FROM Employee;

---

<div class="post-metadata">

**Author:** ![Nolan\_Brewer](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/nolan_brewer/32/7020_2.png) [@Nolan\_Brewer](https://www.techhub.training/u/Nolan_Brewer)\
**Post date:** [February 22, 2025, 6:06pm UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/11 "2025-02-22T18:06:29Z")

</div>

Time to Complete: 10 minutes  
Difficulty: Easy

Q1  
SELECT first\_name, last\_name, employee\_email AS email  
FROM Employee  
UNION  
SELECT first\_name, last\_name, email  
FROM Vendor;  
Q2  
SELECT \*  
FROM Inventory  
UNION  
SELECT \*  
FROM New\_Inventory;  
Q3  
SELECT DISTINCT emp\_reviewer\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT DISTINCT emp\_order\_creation\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT employee\_id  
FROM Employee;

---

<div class="post-metadata">

**Author:** ![Lucas\_Argente](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/lucas_argente/32/7381_2.png) [@Lucas\_Argente](https://www.techhub.training/u/Lucas_Argente)\
**Post date:** [February 22, 2025, 7:31pm UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/12 "2025-02-22T19:31:40Z")

</div>

Time to complete: 10 Minutes  
Difficulty: Easy  
Solution:  
Q1:  
SELECT first\_name, last\_name, employee\_email AS email  
FROM Employee  
UNION  
SELECT first\_name, last\_name, email  
FROM Vendor;  
Q2:  
SELECT \*  
FROM New\_Inventory  
UNION  
SELECT \*  
FROM Inventory;  
Q3:  
SELECT DISTINCT emp\_reviewer\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT DISTINCT emp\_order\_creation\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT employee\_id  
FROM Employee;

---

<div class="post-metadata">

**Author:** ![Cooper\_Wise](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/cooper_wise/32/7383_2.png) [@Cooper\_Wise](https://www.techhub.training/u/Cooper_Wise)\
**Post date:** [February 22, 2025, 11:31pm UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/13 "2025-02-22T23:31:59Z")

</div>

Time to complete: 10 min  
Difficulty: Easy  
Solution:  
1.  
SELECT first\_name, last\_name, employee\_email AS email  
FROM Employee  
UNION  
SELECT first\_name, last\_name, email  
FROM Vendor;  
2.  
SELECT \*  
FROM New\_Inventory  
UNION  
SELECT \*  
FROM Inventory;  
3.  
SELECT DISTINCT emp\_reviewer\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT DISTINCT emp\_order\_creation\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT employee\_id  
FROM Employee;

---

<div class="post-metadata">

**Author:** ![McKenna\_Hall](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/mckenna_hall/32/7378_2.png) [@McKenna\_Hall](https://www.techhub.training/u/McKenna_Hall)\
**Post date:** [February 23, 2025, 1:23am UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/14 "2025-02-23T01:23:28Z")

</div>

Time to complete: 10 minutes  
Difficulty: Easy  
Solution:

1. SELECT e.first\_name, e.last\_name, e.employee\_email AS email  
FROM Employee AS e  
UNION  
SELECT v.first\_name, v.last\_name, v.email  
FROM Vendor AS v;

2. SELECT \*  
FROM New\_Inventory  
UNION  
SELECT \*  
FROM Inventory;

3. SELECT DISTINCT o.emp\_reviewer\_id AS employee\_id  
FROM Orders AS o  
UNION ALL  
SELECT DISTINCT o.emp\_order\_creation\_id AS employee\_id  
From Orders AS o  
UNION ALL  
SELECT e.employee\_id  
FROM Employee AS e;

---

<div class="post-metadata">

**Author:** ![Shane\_Hawkins](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/shane_hawkins/32/6951_2.png) [@Shane\_Hawkins](https://www.techhub.training/u/Shane_Hawkins)\
**Post date:** [February 23, 2025, 5:05am UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/15 "2025-02-23T05:05:28Z")

</div>

Time to Complete: 10 minutes  
Difficulty: Easy  
Solution: See Below

1. SELECT e.first\_name, e.last\_name, e.employee\_email as email  
from Employee as e  
UNION  
select v.first\_name, v.last\_name, v.email  
from Vendor as v
2. SELECT \*  
from New\_Inventory  
UNION  
SELECT \*  
from Inventory
3. SELECT DISTINCT emp\_reviewer\_id as employee\_id  
from Orders  
union all  
select DISTINCT emp\_order\_creation\_id as employee\_id  
from Orders  
union ALL  
select employee\_id  
from Employee;

---

<div class="post-metadata">

**Author:** ![Amanda\_Garton](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/amanda_garton/32/7384_2.png) [@Amanda\_Garton](https://www.techhub.training/u/Amanda_Garton)\
**Post date:** [February 23, 2025, 6:38am UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/16 "2025-02-23T06:38:43Z")

</div>

1. SELECT first\_name, last\_name, employee\_email AS email  
FROM Employee  
UNION  
SELECT first\_name, last\_name, email  
FROM Vendor;
2. SELECT \*  
FROM Inventory  
UNION  
SELECT \*  
FROM New\_Inventory
3. SELECT DISTINCT emp\_reviewer\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT DISTINCT employee\_id  
FROM Employee  
UNION ALL  
SELECT DISTINCT emp\_order\_creation\_id AS employee\_id  
FROM Orders;

---

<div class="post-metadata">

**Author:** ![Henry\_Chen](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/henry_chen/32/6979_2.png) [@Henry\_Chen](https://www.techhub.training/u/Henry_Chen)\
**Post date:** [February 23, 2025, 7:42am UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/17 "2025-02-23T07:42:09Z")

</div>

Time 15

Intermidiate

1. SELECT first\_name, last\_name, employee\_email AS email  
FROM Employee

UNION

SELECT first\_name, last\_name, email  
FROM Vendor;

1. 

SELECT \*

FROM New\_Inventory

Union

SELECT \*

FROM Inventory  
3.

SELECT DISTINCT emp\_reviewer\_id AS employee\_id

FROM Orders

Union ALL

SELECT DISTINCT emp\_order\_creation\_id AS employee\_id

FROM Orders

Union ALL

SELECT employee\_id

FROM Employee

---

<div class="post-metadata">

**Author:** ![Meilan\_Rhoton](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/meilan_rhoton/32/7386_2.png) [@Meilan\_Rhoton](https://www.techhub.training/u/Meilan_Rhoton)\
**Post date:** [February 23, 2025, 9:20pm UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/18 "2025-02-23T21:20:11Z")

</div>

Time 10  
Beginner / Intermediate

1. SELECT v.first\_name, v.last\_name, v.email  
FROM Vendor AS v  
UNION SELECT e.first\_name, e.last\_name, e.employee\_email AS email  
FROM Employee AS e;

2. SELECT \*  
FROM New\_Inventory  
UNION SELECT \*  
FROM Inventory;

3. SELECT DISTINCT orders.emp\_reviewer\_id AS Employee\_id  
FROM Orders  
UNION ALL  
SELECT DISTINCT orders.emp\_order\_creation\_id AS Employee\_Order\_Creation  
FROM Orders  
UNION ALL  
SELECT employee.employee\_id  
FROM employee

---

<div class="post-metadata">

**Author:** ![Cannon\_Hamilton](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/cannon_hamilton/32/7390_2.png) [@Cannon\_Hamilton](https://www.techhub.training/u/Cannon_Hamilton)\
**Post date:** [February 24, 2025, 2:16am UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/19 "2025-02-24T02:16:50Z")

</div>

Q1: SELECT first\_name, last\_name, employee\_email AS email  
FROM Employee  
UNION  
SELECT first\_name, last\_name, email  
FROM Vendor;

Q2: SELECT \*  
FROM New\_Inventory  
UNION  
SELECT \*  
FROM Inventory;

Q3: SELECT DISTINCT emp\_reviewer\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT DISTINCT emp\_order\_creation\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT employee\_id  
FROM Employee;

---

<div class="post-metadata">

**Author:** ![Rylee\_Schriever](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/rylee_schriever/32/6914_2.png) [@Rylee\_Schriever](https://www.techhub.training/u/Rylee_Schriever)\
**Post date:** [February 24, 2025, 4:37am UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647/20 "2025-02-24T04:37:06Z")

</div>

15 minutes  
medium hard

1. SELECT employee.first\_name, employee.last\_name, employee.employee\_email AS email  
FROM Employee  
UNION  
SELECT vendor.first\_name, vendor.last\_name, vendor.email  
FROM Vendor;

2. SELECT \*  
FROM New\_Inventory  
UNION  
SELECT \*  
FROM Inventory;

3. FROM Orders  
UNION ALL  
SELECT emp\_order\_creation\_id AS employee\_id  
FROM Orders  
UNION ALL  
SELECT employee\_id  
FROM Employee;

[Next page](https://www.techhub.training/t/178-sql-unions-with-precision/2647.md?page=2)