Home Forums SQL Server 2008 T-SQL (SS2K8) Proplem Put Filter ("And" or "Or") in Query RE: Proplem Put Filter ("And" or "Or") in Query

  • September 5, 2013 at 5:06 am

    #1647653

    excuseme

    Contact information table was forgotten

    Plz Download New Database Attachment

    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)

    I want someone who uses both(Walker and Cane ) to exhibit = Mike

    But it does not display anything.