SQL SERVER 2000 - Searching Inside A Table That Is Inner Joined With A Sub Table Returns Duplicates

Experts,

Ive got a query that searches inside a table called Questions. This table is linked to QuestionCategories, in a one to many relation.

I want the user to be able to search in the questions, but my problem is that it returns the same record in duplicates depending on how many categories is this question related to.

The search is open, it searches for the same keyword in all fields, even the category name that is in a different table.

How may I achieve returning a result set that meets the users search but dont show the same record more than once.

I am attaching my stored procedure.

Thanks in advance

CREATE PROCEDURE [FAQ_OpenSearch]
(
	@keyword nvarchar(100)
)
AS
BEGIN
	SET NOCOUNT ON
	DECLARE @Err int
 
 
 
	SELECT    Q.Module_IKey,Q.IKey,Q.QuestionTitle, Q.QuestionHTML, C.CategoryName, S.SoftwareManufacturer, S.ProductName AS S_ProductName, S.SoftwareVersion, 
                      S.OtherDetails AS S_OtherDetails, H.HardwareManufacturer, H.ProductName AS H_ProductName, H.ProductModel, H.OtherDetails AS H_OtherDetails, 
                      D.[Language], D.Browser, D.URL, E.ErrorMessage, O.RelatedInformation, U.FullName
	FROM         dbo.FAQ_Question Q INNER JOIN
                      dbo.sys_Users U ON Q.EditedBy = U.IKey INNER JOIN
                      dbo.FAQ_QuestionCategories QC ON Q.IKey = QC.Question_IKey INNER JOIN
                      dbo.FAQ_Categories C ON QC.Category_IKey = C.IKey LEFT OUTER JOIN
                      dbo.FAQ_QuestionTags_Hardware H ON Q.IKey = H.Question_IKey LEFT OUTER JOIN
                      dbo.FAQ_QuestionTags_Software S ON Q.IKey = S.Question_IKey LEFT OUTER JOIN
                      dbo.FAQ_QuestionTags_Development D ON Q.IKey = D.Question_IKey LEFT OUTER JOIN
                      dbo.FAQ_QuestionTags_OtherInformation O ON Q.IKey = O.Question_IKey LEFT OUTER JOIN
                      dbo.FAQ_QuestionTags_ErrorMessages E ON Q.IKey = E.Question_IKey
 
 
	WHERE
		(
			 	CategoryName			LIKE '%' + @keyword + '%'
			OR 	QuestionHTML			LIKE '%' + @keyword + '%'
			OR 	QuestionTitle			LIKE '%' + @keyword + '%'
			OR 	RelatedInformation		LIKE '%' + @keyword + '%'
			OR 	S.OtherDetails			LIKE '%' + @keyword + '%'
			OR 	SoftwareVersion			LIKE '%' + @keyword + '%'
			OR 	S.ProductName			LIKE '%' + @keyword + '%'
			OR 	SoftwareManufacturer		LIKE '%' + @keyword + '%'
			OR 	H.OtherDetails			LIKE '%' + @keyword + '%'
			OR 	ProductModel			LIKE '%' + @keyword + '%'
			OR 	H.ProductName			LIKE '%' + @keyword + '%'
			OR 	HardwareManufacturer		LIKE '%' + @keyword + '%'
			OR 	ErrorMessage			LIKE '%' + @keyword + '%'
			OR 	URL				LIKE '%' + @keyword + '%'
			OR 	Browser				LIKE '%' + @keyword + '%'
			OR 	Language			LIKE '%' + @keyword + '%'
	
		)
	
 
 
	ORDER BY Q.SystemDate DESC
 
 
	SET @Err = @@Error
	RETURN @Err
END
GO

Select allOpen in new window