what is the difference between union and union all

union is used to select distinct values from two tables 
where as union all is used to select all values including 
duplicates from the tables