First Table Personal Information Included Feilds :

NationalCode(Key), FirstName, LastName, CompanyID, NCode, FatherName, nPercent,

Second Table Tools Information Included Feilds :

ID_Tools(key),NationalCode ,TypeTools,NameTools,PriceTools

Third View(View_Report) Included Feilds :

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

Now the query is (Posted by Hanshy for a table is queried) :

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

FROM View_Report

WHERE (NameTools = N'Walker') OR

(NameTools = N'Cane')

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

HAVING (COUNT(NameTools) = 2)

Please help me know what to do (For View)