where clause: if this value from col x make sure col y is this value I feel like this is an easy one for you Experts!  I haven't done any kind of Advanced SQL in years.

Fundamental question:

select
    *
from myTable
where ((if col1 = 'this', make sure col2 = 'that')
else, don't include it in the results)


I would want to include all of this in my result set EXCEPT the first row, because where col1 = 'this'  col2 doesn't = 'that'

I want to only check where col1 = 'this' .. other values I want to include in the results.

How do I do the above logic in SQL Oracle.  I don't want to use PL/SQL  just plain SQL.
I was thinking there was a clever way to do this without some weird if/then/else statement

Thank you,
Mike
Like this:

select * from myTable 
where colY = 'that' or colX &lt;&gt; 'this'


The standard implementation of any criteria specified as A =&gt; B is as B or not A

Update:

Using this CTE for sample data:

with myTable as (
    select N,colX,colY from ( values
         (1,'this','hey')
        ,(2,'this','that')
        ,(3,'yup', 'yerp')
        ,(4,'yup', 'that')
    ) myTable(N,colX,colY)
)


and this query from above:

select * from myTable 
where colY = 'that' or colX &lt;&gt; 'this'


yields (as required):

N           colX colY
----------- ---- ----
2           this that
3           yup  yerp
4           yup  that

(3 row(s) affected)