• If you change your UNION to a UNION ALL, it will work. Note that it will not filter out duplicates like UNION will.