• Home
  • Jobs
  • Courses
  • Certifications
  • Companies
  • Online IDE
  • Login
  • Signup
MySQL
  • Introduction To MySQL
  • MySQL RDBMS
  • MySQL SQL
  • MySQL SELECT Statement
  • MySQL WHERE Clause
  • MySQL AND, OR And NOT Operators
  • MySQL ORDER BY Keyword
  • MySQL INSERT INTO Statement
  • MySQL NULL Values
  • MySQL UPDATE Statement
  • MySQL DELETE Statement
  • MySQL LIMIT Clause
  • MySQL MIN() And MAX() Functions
  • MySQL COUNT(), AVG() And SUM() Functions
  • MySQL LIKE Operator
  • MySQL Wildcards
  • MySQL IN Operator
  • MySQL BETWEEN
  • MySQL Aliases
  • MySQL Joins
  • MySQL INNER JOIN Keyword
  • MySQL LEFT JOIN Keyword
  • MySQL RIGHT JOIN Keyword
  • MySQL CROSS JOIN Keyword
  • MySQL Self Join
  • MySQL UNION Operator
  • MySQL GROUP BY Statement
  • MySQL HAVING Clause
  • MySQL EXISTS Operator
  • MySQL ANY And ALL Operators
  • MySQL INSERT INTO SELECT Statement
  • MySQL CASE Statement
  • MySQL NULL Functions
  • MySQL Comments
  • MySQL Operators
  • MySQL CREATE DATABASE Statement
  • MySQL DROP DATABASE Statement
  • MySQL CREATE TABLE Statement
  • MySQL DROP TABLE Statement
  • MySQL ALTER TABLE Statement
  • MySQL Constraints
  • MySQL NOT NULL Constraint
  • MySQL UNIQUE Constraint
  • MySQL PRIMARY KEY Constraint
  • MySQL FOREIGN KEY Constraint
  • MySQL CHECK Constraint
  • MySQL DEFAULT Constraint
  • MySQL CREATE INDEX Statement
  • MySQL AUTO INCREMENT Field
  • MySQL Working With Dates
  • MySQL Views
  • MySQL Data Types
  • MySQL Functions
  • Home
  • Courses
  • MySQL
  • MySQL UNION Operator

MySQL UNION Operator

Previous Next

The MySQL UNION Operator

The UNION operator is used to combine the result-set of two or more SELECT statements.

Every SELECT statement within UNION must have the same number of columns
The columns must also have similar data types
The columns in every SELECT statement must also be in the same order

UNION Syntax

SELECT column_name(s) FROM table1
UNION
SELECT column_name(s) FROM table2;



Practice Excercise Practice now

UNION ALL Syntax

The UNION operator selects only distinct values by default. To allow duplicate values, use UNION ALL:
 

SELECT column_name(s) FROM table1
UNION ALL
SELECT column_name(s) FROM table2;



Practice Excercise Practice now

Demo Database

In this tutorial we will use the well-known Northwind sample database.

Below is a selection from the "Customers" table:

CustomerID CustomerName ContactName Address City PostalCode Country
1
 
Alfreds Futterkiste Maria Anders Obere Str. 57 Berlin 12209 Germany
2 Ana Trujillo Emparedados y helados Ana Trujillo Avda. de la Constitución 2222 México D.F. 05021 Mexico
3 Antonio Moreno Taquería Antonio Moreno Mataderos 2312 México D.F. 05023 Mexico

And a selection from the "Suppliers" table:
SupplierID SupplierName ContactName Address City PostalCode Country
1 Exotic Liquid Charlotte Cooper 49 Gilbert St. London EC1 4SD UK
2 New Orleans Cajun Delights Shelley Burke P.O. Box 78934 New Orleans 70117 USA
3 Grandma Kelly's Homestead Regina Murphy 707 Oxford Rd. Ann Arbor 48104 USA



Practice Excercise Practice now

SQL UNION Example

The following SQL statement returns the cities (only distinct values) from both the "Customers" and the "Suppliers" table:
 

SELECT City FROM Customers
UNION
SELECT City FROM Suppliers
ORDER BY City;



Practice Excercise Practice now

SQL UNION ALL Example

The following SQL statement returns the cities (duplicate values also) from both the "Customers" and the "Suppliers" table:

SELECT City FROM Customers
UNION ALL
SELECT City FROM Suppliers
ORDER BY City;

 



Practice Excercise Practice now

SQL UNION With WHERE

The following SQL statement returns the German cities (only distinct values) from both the "Customers" and the "Suppliers" table:
 

SELECT City, Country FROM Customers
WHERE Country='Germany'
UNION
SELECT City, Country FROM Suppliers
WHERE Country='Germany'
ORDER BY City;



Practice Excercise Practice now

SQL UNION ALL With WHERE

The following SQL statement returns the German cities (duplicate values also) from both the "Customers" and the "Suppliers" table:
 

SELECT City, Country FROM Customers
WHERE Country='Germany'
UNION ALL
SELECT City, Country FROM Suppliers
WHERE Country='Germany'
ORDER BY City;



Practice Excercise Practice now

Another UNION Example

The following SQL statement lists all customers and suppliers:
 

SELECT 'Customer' AS Type, ContactName, City, Country
FROM Customers
UNION
SELECT 'Supplier', ContactName, City, Country
FROM Suppliers;



Practice Excercise Practice now

Previous Next
COMPANY
  • About us
  • Careers
  • Contact Us
  • In Press
  • People
  • Companies List
Products
  • Features
  • Coding Assessments
  • Psychometric Assessment
  • Aptitude Assessments
  • Tech/Functional Assessments
  • Video Assessment
  • Fluency Assessment
  • Campus
 
  • Learning
  • Campus Recruitment
  • Lateral Recruitment
  • Enterprise
  • Education
  • K 12
  • Government
OTHERS
  • Blog
  • Terms of Services
  • Privacy Policy
  • Refund Policy
  • Mart Category
Partner
  • Partner Login
  • Partner Signup

Copyright © RVR Innovations LLP 2025 | All rights reserved - Mytat.co is the venture of RVR Innovations LLP