Complex SQL question (I think)

I have a SQL statement in a stored procedure that returns a plain select statement perfectly. However, this table is the second lowest level of a table heirarchy (I haven't used any foregin keys or secondary keys though). What I need to do, in one statement, is return a count of records in the next level of the database based on a value withing the select statement that we're making the call with.....any idea of how to do this?

A subselect MAY be what you're after... i think...

http://www.dbbm.fiocruz.br/class/Le...More_Subqueries

thanks, i'll check it out