Codechef4u is a community for computer professionals,by computer professionals,just like you; who loves sharing and helping each others,Join them
Share your post

UNION ALL

The UNION ALL clause/operator is used to combine the results of two or more select statements
Including duplicate rows/records.

Syntax:

SELECT column1 [, column2 ]
FROM table1 [, table2 ]
[WHERE condition]
UNION ALL
SELECT column1 [, column2 ]
FROM table1 [, table2 ]
[WHERE condition]

Example:

SELECT * FROM [UserData]
UNION ALL
SELECT * FROM Employee


Invalid entry,please enter valid data.

Loading