UNION ALL

You can combine multiple tables and queries together by using UNION ALL.

Note: UNION will parse, but it will be treated as UNION ALL –ie. duplicate records kept in the returned data set.

Example:

SELECT * FROM table1 UNION ALL SELECT * FROM table2
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.