each row repeating itself too many times in sql join query

See more:

SQL

 USE [cms]
GO
/****** Object:  StoredProcedure [dbo].[SpGetRelatedProducts]    Script Date: 10/10/2012 23:55:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
alter proc [dbo].[SpGetAllProducts](@cateid int)
AS
select *
from product 
inner join subcategory on subcategory.subcate_id = product.subcate_id
inner join category on subcategory.cate_id = @cateid

i want that all the products, which belong from different subcategory and these subcategories belongs from same category and also the columns of the subcategory table, but in above code thr is a issue that each row repeating itself too many times...?