i'm working with asp.net c#..
i want to make a chart that can retrieve the data from the database..
i found one website that tell the way to make it but i dont understand the query used..
this the the link http://www.dotnetcurry.com/ShowArticle.aspx?ID=238 and the query is
SELECT CategoryName, COUNT(*) AS ProductCount FROM Products JOIN Categories ON Products.CategoryID = Categories.CategoryID GROUP BY CategoryName
anyone can help me translate this query..
1) COUNT(*) is count for the productCount or categoryName?
2) is it necessary to include the join?
3) ProductCount is the attribute that we need to create to pu the result or one of the field in the table in databse?