Home Forums SQL Server 2008 SQL Server Newbies Structure of WHERE clause using "and" / "or" in a multiple criteria query RE: Structure of WHERE clause using "and" / "or" in a multiple criteria query

  • January 12, 2013 at 4:39 pm

    #1576639

    So which ones are you stuck on? Just 7 and 8?

    I don't see why you need to use OR, just AND...

    Surely something like:

    SELECT * from table

    WHERE NOT (clinic_spec IN ( 'ANAES','PAEDS') AND Consultant IN ( 'MDT','GABHOS'))

    would work?