Mrci

You are quite right in my Answer

But I have a view and send it to the different conditions By Collection (Asp.net)

I added the condition to Having, but will not display anything.

SELECT FirstName, LastName, CompanyID, NCode, FatherName, nPercent, NationalCode

FROM View_Report_Payesh_Tools

WHERE (Tools = N'Walker') OR

(Tools = N'Cane')

GROUP BY FirstName, LastName, CompanyID, NCode, FatherName, nPercent, NationalCode

HAVING (COUNT(Tools) = 2)

I Have Two Table ,1-Personal Information,2-Tools Information