Search the Whole World Here.,.,

SQL - UNION ALL Syntax

SQL - UNION ALL Syntax




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.


EmoticonEmoticon

Subscribe to: Post Comments (Atom)