Question

How to combines the result of two or more SELECT statements in SQL

Answer 1

--  SELECT with DISTINCT by default

SELECT FirstName FROM Workers
UNION
SELECT Meal FROM LunchOrders

 

Cleaner teeth, healthier you!
Get The Secret to a Bright and Healthy Smile

Answer 2

SELECT FirstName FROM Workers
UNION
SELECT Meal FROM LunchOrders
ORDER BY Meal

 

Cleaner teeth, healthier you!
Get The Secret to a Bright and Healthy Smile

Answer 3

--  (UNION ALL) SELECT without DISTINCT, allow duplicate 

SELECT FirstName FROM Workers
UNION ALL
SELECT Meal FROM LunchOrders

 

Cleaner teeth, healthier you!
Get The Secret to a Bright and Healthy Smile

Answer 4

SELECT category FROM all_info
UNION
SELECT word FROM words
WHERE word LIKE '%a%'

 

Cleaner teeth, healthier you!
Get The Secret to a Bright and Healthy Smile

Answer 5

SELECT category FROM all_info
UNION
SELECT word FROM words
WHERE word LIKE '%ie%'
Order BY category

 

Cleaner teeth, healthier you!
Get The Secret to a Bright and Healthy Smile