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 2, 2013 at 5:27 am

    #1646722

    Attach Sample Database (SQl 2008)

    My Query is :

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

    FROM View_Report

    WHERE (NameTools = N'walker') OR

    (NameTools = N'Cane')

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

    Request is consistent with the first post (Only Display Mike)