I have a table called MYTABLE with two bit data type columns I want to compare these two columns and depending on their value I want it to place the value in a 3rd column.
So here is my truth table, so the only time my third column should have the value of one is when COL1 and COL2 are both zero.
COL1 COL2 MyDesiredColumn
0 0 1
0 1 0
1 0 0
1 1 0
NULL 0 0
NULL 1 0
Can anyone help me with this query?
So far I have this but I'm stuck on what I need to put on my third column to follow my truth table from above.