Syntax of UNION Operator in SQL

Posted Date: 14 Jul 2008 Resource Type: Code Snippets Category: SQL

Posted By: Kundan Kumar Sinha Member Level: Gold
Rating:

Points: 5

We can combine the results of two or more Select statements into a single result set by using the UNION operator. To combine the results of multiple queries in a single result set with the condition that the number of columns must be same in each query and the format of each data type must be same of corresponding columns.

Syntax for the Union Command is given below.



SELECT Field_names
   FROM Table_Name1
     WHERE Condition
UNION
SELECT Field_names
   FROM Table_Name2
     WHERE Condition

Responses

Author: UltimateRengan 16 Jul 2008 Member Level: Diamond Points : 1

hi,

really nice one.
continue to posting such valuable articles
ya its woriking fine.
by
G.RengaNathan

Feedbacks

Popular Tags

What are tags ?

Search Tags

UNION Operator . UNION operator syntax . UNION Operator in SQL . Syntax of UNION Operator in SQL . Syntax of UNION Operator .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Stored Procedure to Calculate an Employee's PF and PT
	Previous Resource: CASE Statements in SQL Server
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

doors in nj