Union is one of the SQL syntax for combine the results of two queries together.

Do you know what is are the differences between UNION and UNION ALL ? (ehee….this is one of my interview question,lucky i know the answer. )

The UNION ALL command is equal to the UNION command, except that UNION ALL selects all values.(including all the duplicate values)

Links:

http://www.w3schools.com/sql/sql_union.asp

Happy Programming….