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