SQL - Union Statement

When it comes to data manipulation there is only so much you can do. Most of the options on data manipulation stem from three sources:

1. Field Manipulation (the likes of case statements, if statements etc..)

2. Join Manipulation (obtaining details by linking to other tables)

3. Unions (the purpose of this video ;o))

Unions allow you to "abut" two seperate data sources and place them in one datasource. This is not for the likes of customers and orders but rather the ability to have customers and employees in the same datasource.

A good example of this is if you want an address list, both tables of customers and employees house disperate data but in the confines of a address list they are in most repsects the same.

So this short and sweet video explains the "Union" and "Union All" statements to allow you to fully understand the differences.

Enjoy!

Category:

Education

Tags:

• Data
• Microsoft
• Microsoft SQL
• Microsoft SQL Basics
• Select
• SQL
• SSIS
• SSMS
• training
• demo
• tutorial
• teach me
• howto
• how to
• Select statement
• select
• database
• merge
• join
• tables
• fields
• Microsoft SQL Server
• software tutorial

[grldescms]

your voice is so LOUD!!!

[PCTeachME]

@grldescms Hi, Appologies for the sound. My regular microphone was not working that day to the sound is very muffled and full of bass (which is not the norm). Still, I do hope the video helped you out.

[PCTeachME]

Sure, just put "union" underneath the last select statement and then carry on. Make sure the select statement has the same number of feilds etc...

[grldescms]

ahhh okey okey no prob!! ^___^

[adamfurio]

Good stuff : )

[IDaRsHaNI]

Is there any way you can union more than two tables?