This doesn't seem clean to me but it worked...

SELECT (SELECT COUNT(DocVersion.object_class_id)

FROM ClassDefinition

INNER JOIN DocVersion ON ClassDefinition.object_id = DocVersion.object_class_id

where DocVersion.version_status = '1' AND ClassDefinition.symbolic_name = 'HQANGDocument'

group by ClassDefinition.symbolic_name, DocVersion.object_class_id) +

(SELECT...

No it is not.

Thank you for your help. I'm pretty new to using sql and haven't had much experiencewith subqueries. Totally forgot about that. Thank you again.

The table I'm working with is kind of goofy. It has 2 ID fields.

Select strControlNbr From tblBonus Where intBonusID = @ID;

Select intBonusID From tblBonus Where strControlNbr = @strControlNbr

So...