SELECT count(*), ID 
FROM IDTable
GROUP BY ID
OUTER JOIN SumTable ON IDTable.ID = SumTable.ID