Writing a SQL stmt with specific where conditions
Posted on 2014-08-19
I am drawing a blank on this.
I want to return a recordset where I have two conditions to be met.
Here is my data
Col1 col2 col3 col4
1 n t p
2 n r g
3 n r n
4 o t x
5 o t n
OK I want to return all records except for record 5 where col3=t and col4=n
I require all the other columns to be returned. I cannot reference Col1 in the where clause
Maybe I need something like a union which I do not know the syntax.