Exclude records verifying two conditions

select, sql, sql-server

Solution

Use this:

and not (currentdoctype='PUSH' and CurrentDocEntry=15)

Problem

``` select * from table_name where BaseDocEntry=15 and BaseDocType='PRRH' and ItemCode='TestStudy2' and WhseCode='01' and (currentdoctype<>'PUSH' and CurrentDocEntry<>15) ``` According to the query I have written above, the data from INS2 will be fetched excluding the currentdoctype [PUSH] and all data where CurrentDocEntry is not 15. What I expect my query to be is, it must exclude the data only if this combination i.e. currentdoctype=PUSH and CurrentDocEntry=15 are occurring in the same row, then exclude that row. Can you fix this query ?

Original source