1
Answer

how to count group by in sql server

i have a query 
 
 
in this query:
 
i want to count each shape have many products--------- 
 
SELECT tbl_shape.Shape,tbl_Image_Master.TagName, tbl_Image_Master.ProCode, tbl_shape.ShapeId, tbl_Image_Master.Shape_Id
FROM tbl_shape INNER JOIN tbl_Image_Master ON tbl_shape.ShapeId = tbl_Image_Master.Shape_Id
 
Answers (1)