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 2014 Standard Edition Server w/20 CAL’s

Price: $641.99
Buy It Now
Microsoft SQL Server 2008 R2 Standard Server License key +5CAL FactorySealedPack

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

Price: $899
Buy It Now
Microsoft SQL Server 2012 Standard with SP3 - 25 CAL License - SAME DAY DOWNLOAD

Price: $700
Buy It Now
Lenovo Microsoft SQL Server 2014 - License - 1 User CAL - OEM

Price: $169.99
Buy It Now
Microsoft SQL Server Standard 2014 + 10 Cal

Current Price: $122.5
Current Bids: 8







Copyright 2017 - TSQLTutorials.com