Counting Records

I have a table with 3 nested tables in it. I want to be able to return the number of rows retrieved from each nested table in my result set.

This cannot be just a simple count, as if the nested tables have 100 rows each, but the result set selects 10 from nested table 1, 50 from nested table 2 & 25 from nested table 3.

Is there a way for me to get this count? Received on Mon Aug 01 2011 - 10:16:08 CDT