AAAARRRGGGGGGG!!!!!!!!!
I was making a simple insert script in SQL with the where clause having a "Not in (Select example from table A)"
I was told that this particular table A is not allowed to have nulls in the column example.
So I spend a good amount of time looking at this damn simple ass query thinking that I'm stupid because it makes sense to me but clearly there is something wrong. eventually in the back of my mind something tells me to just check for nulls, which I didn't do to start with because I was told that there cannot be any nulls and BEHOLD!!! fckn nulls......
Go to the guy who created the table and the sql shit i'm trying to fix who was the person who stated that the column cannot be null.
Tell him there are nulls.
Him: if the value in table B is null then it will be null in table A
Me: you said that there cannot be nulls in Table A
Him: Yes, there can't be any nulls
Me: But there are nulls...
Him: Yes, there will be nulls
Me: You said there CANNOT be any nulls.
Him: yes....
I have no idea how this dip of a person can be considered to have any form of intelligence.