Suppose I have some table named tableA and column1 in tableA has some null values and strings.
Also suppose I had created some temporary table named tempTable that has only 1 column. And that 1 column contains null values and strings as well.
I have a statement similar to the following:
select * from tableA where tableA.column1 in (select * from tempTable);
However, I want it to also select the contents when tableA.column1 is null. The in operator ignores that case.
Is there a different operator that considers null?
Or is there anyway I can apply certain constraints in the where clause under true or false conditions.
Like for example in the incorrect statement below:
select * from tableA where (if condition1, then tableA.column1 =.... elseif condition2 then tableA.column1 =....);