T-SQL Tutorials - TSQLTutorials.com

UNION - Join Data Sets


Introduction

The UNION keyword in TSQL is used to combine two datasets. The two datasets must have the same number of columns in them and use the same datatypes. The datasets must also have the columns in the same comparative order. The UNION T-SQL Expression places the UNION keyword between two datasets. By using the UNION keyword between two datasets, TSQL will return a new dataset that contains what is in the first dataset and also what is in the second dataset. All the records in the new dataset that is created using the UNION keyword, will be distinct. That means that if there are multiple records in datasets that have exactly the same values, the resulting dataset will only contain one those records with those values. The UNION keyword is often used in this fashion:

  • SELECT col1,col2,coln... FROM table1 '[DataSet #1]
  • UNION
  • SELECT col1,col2,coln... FROM table2 '[DataSet #2]


Microsoft SQL Server 2008 R2 Standard Server License key +5CAL FactorySealedPack

Price: $495
Buy It Now
Add-On Microsoft SQL Server 2008 R2 5CAL Standard Enterprise Datacenter Sealed!

Price: $199
Buy It Now
Brand New - Microsoft SQL Server 2014 Standard Edition SP2 and 25 CAL License

Price: $899
Buy It Now
Microsoft SQL Server 2012 Standard 10CAL +Server License Key Factory Sealed Pack

Price: $949
Buy It Now
Factory Sealed- 228-10602 Microsoft SQL Server 2016 Standard 10 CAL NEW!!

Price: $2169.99
Buy It Now
Factory Sealed - 228-09180 Microsoft SQL Server 2008 R2 Standard 10 CAL

Price: $1599
Buy It Now







Copyright 2017 - TSQLTutorials.com