Hi Good People,
I am stuck in many-to-many relationship problem in IBatis. I have the following scenario:
As you can see third table implementing M:M relationship.
Table: cutomers (custid, custname)
Table: Product (prodid, prodname)
Table: Billing (billingid, custid, prodid)
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 :
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?
SELECT prodid, (select count(*) custid from billing where billing.prodid=prod.prodid) as NO_of_customers,DESCRIPTION FROM prod
Please suggest me if any one has any idea?
Thanks and Regards,