Combining Result Sets by Using MySQL UNION: Examples

Examples
Sample Database

#1

SELECT
	customerNumber id,
	contactLastname NAME
FROM
	customers
UNION
	SELECT
		employeeNumber id,
		firstname NAME
	FROM
		employees

#2

(
	SELECT
		customerNumber,
		contactLastname
	FROM
		customers
)
UNION
	(
		SELECT
			employeeNumber,
			firstname
		FROM
			employees
	)
ORDER BY
	contactLastname,
	customerNumber

#3

(
	SELECT
		customerNumber id,
		contactLastname NAME
	FROM
		customers
)
UNION
	(
		SELECT
			employeeNumber id,
			firstname NAME
		FROM
			employees
	)
ORDER BY
	NAME,
	id

#4

(
	SELECT
		customerNumber,
		contactLastname
	FROM
		customers
)
UNION
	(
		SELECT
			employeeNumber,
			firstname
		FROM
			employees
	)
ORDER BY
	2,
	1;

Table List

customers

SELECT * FROM customers;

employees

SELECT * FROM employees;

offices

SELECT * FROM offices;

orderdetails

SELECT * FROM orderdetails;

orders

SELECT * FROM orders;

payments

SELECT * FROM payments;

productlines

SELECT * FROM productlines;

products

SELECT * FROM products;

Result