The UNIONs were introduced in MySQL 4. The unions are useful if you wish to join the results from more than one query, but be aware that the number of the returned columns by each select query should be the same.
(as well as their type)
 
The very simple example below show you the basics of the UNION statement
 
SELECT id, name FROM my_table
UNION
SELECT id, name FROM my_table;

Send to a friend

Close

• Social Web
• E-Mail
• Link Codes

Delicious Digg StumbleUpon Propeller Reddit Magnoliacom Newsvine Furl Facebook Google Yahoo Technorati Icerocket

Your Email: *

Your Name: *

Send To: *

Enter one address or multiple addresses separated with commas.

Direct URL

HTML Code

Forum Code