SQL - UNION Syntax Knowledge Based Info. MySQL SELECT column_name(s) FROM table1 UNION SELECT column_name(s) FROM table2; Note: The UNION operator selects only distinct values by default. To allow duplicate values, use the ALL keyword with UNION. Share this Share on FacebookTweet on TwitterPlus on Google+
EmoticonEmoticon