All the UNION ALL should do is to combine those result sets. <BR><BR>The UNION would remove "duplicates" as default behavior in MySql, however that seems to be not what you want if all you are ...