<p>What is the difference between <code>UNION</code> and <code>UNION ALL</code>?</p>

The basic difference between UNION and UNION ALL is union operation eliminates the duplicated rows from the result set but union all returns all rows after joining.
from
http://zengin.wordpress.com/2007/07/31/union-vs-union-all/