What is the difference between UNION and UNION ALL?
* UNION : To select related information from two tables UNIONcommand is used. It is similar to JOINcommand.
* UNION ALL : The UNION ALL command is equal to the UNIONcommand, except that UNION ALL selects all values. It will not remove duplicate rows, instead it will retrieve all rows from all tables.