gistfile1.sql

SELECT 1 AS ID
	INTO #left
UNION
SELECT 2
UNION 
SELECT 3
UNION 
SELECT 4;


SELECT 1 AS ID
	INTO #right


SELECT COUNT(*), tl.total
FROM #left l
	left join #right r
		on l.id = r.id
	cross join
		(
			SELECT 
				COUNT(*) as total
				, 0 as id
			FROM #left
		) tl
WHERE r.id IS NULL
GROUP BY tl.total;


DROP TABLE #left;
DROP TABLE #right;