Many to Many relationship on IBatis

[Khushwinder]

Hi Good People,

I am stuck in many-to-many relationship problem in IBatis. 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 write this query in sql map files and also how should i retrieve data in the UI?

Please suggest me if any one has any idea?

Thanks and Regards,
Khushwinder

[Khushwinder]

If any one has any idea suggest me.
I am waiting for your answers...