SELECT column_name(s) FROM table1
UNION ALL
SELECT column_name(s) FROM table2;
Note : The column names in the result-set of a UNION are usually equal to the column names in the first SELECT statement in the UNION.
SQL - UNION ALL Syntax
Subscribe to:
Post Comments (Atom)
EmoticonEmoticon