I need select 200 user and count students for their

For Example :
select user.name, count(st.id)
from user, studend st
where user.st_id = st.id

I think that select 200 queries It isn't correct

How it make correct ? Please give me link to read

Thanks



Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

Try this