group by with inner join sqlserver

Question

hi frnds i want to count how many shape in single category plz solve this problem ================= ======================= SELECT tbl_category.Category_Name tbl_shape.Shape FROM tbl_category INNER JOIN tbl_Image_Master ON tbl_category.Cat_Id = tbl_Image_Master.Cat_Id INNER JOIN tbl_shape ON tbl_Image_Master.Shape_Id = tbl_shape.ShapeId

Devendra Kumar · Answer

hello plz i want to like this category name: precious have one shape: coin(2) and it have two product

Manas Mohapatra · Answer

Try like below: SELECT tbl_category.Category_Name Count(tbl_category.Category_Name) AS NoOfShape FROM tbl_category INNER JOIN tbl_Image_Master ON tbl_category.Cat_Id = tbl_Image_Master.Cat_Id INNER JOIN tbl_shape ON tbl_Image_Master.Shape_Id = tbl_shape.ShapeId GROUP BY tbl_category.Category_Name