Exclude records verifying two conditions

Question

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 ?

Answer 1

Use this:

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

Answer 2

Since you're using AND and not OR the query is excluding when currentdoctype is different from 'PUSH' and CurrentDocEntry different from 15.

If you want currentdoctype=PUSH and CurrentDocEntry=15 just put those conditions instead:

select * from ins2
where BaseDocEntry=15 and BaseDocType='PRRH' and ItemCode='TestStudy2'
and WhseCode='01' and (currentdoctype='PUSH' and CurrentDocEntry=15)