Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Basics in MS SQL Server

Introduction
UNION
7. Conditions for UNION
INTERSECT
EXCEPT

Instruction

Okay, how does the magic work? How can we show two tables as one?

As you can probably imagine, both tables must have the same number of columns, so that the results can be merged into one table.

Makes sense, right? You should also remember that the respective columns must have the same kind of information: numerical or text. If one of your tables puts numbers in the Place column (1, 2, 3) and the other puts texts ('first', 'second', 'third'), UNION won't work.

Exercise

Click Next exercise to continue.