Make sure you use UNION ALL, not UNION