Many to Many relationship Query in hibernate

[Khushwinder Chahal]

Hi Good People,

I am stuck in many-to-many relationship problem in Hibernate. I have the following scenario:

Table: cutomers (custid, custname) 

Table: Product (prodid, prodname)

Table: Billing (billingid, custid, prodid)

As you can see third table implementing M:M relationship.

Now i want to display in the UI like :

List of products along with total number of customers in each product.

I have made database query for this problem like :

SELECT   prodid, (select count(*) custid from billing where billing.prodid=prod.prodid) as NO_of_customers,DESCRIPTION  FROM prod

after that i am unable to understand how should i map this query to any object class ?

Please suggest me if any one has any idea?

Thanks and Regards,
Khushwinder