SELECT 1+a, 1 FROM qn WHERE b IN (0,1) AND a<@m UNION ALL SELECT 1+a, 2 FROM qn WHERE b IN (0,2) AND a<@m UNION ALL SELECT 1+a, 3 FROM qn WHERE b IN (0,3) AND a<@m ) SELECT COUNT(*) FROM qn; ERROR ...