how can I specify in the <sql-query... that my stored procedure returns
values from more than one table that conceptually should map to more than one domain object.

I have many stored procedures and all of them return various combinations of fields from various tables. So inside which class tag should I put sql-query ?

Perhaps an example could be provided ?
thankyou
AJ

check out pg 162 & 3 of reference.pdf
it shows you how to do what you want

http://www.hibernate.org/hib_docs/v3/reference/en/pdf/hibernate_reference.pdf