Why does MS SQL int != null say false?

N

Nursultan Moldobaev2014-09-25 11:21:07

SQL

Nursultan Moldobaev, 2014-09-25 11:21:07

I compare two tables Join'om I receive the table where there are lines with columns id1 ld1 am1 and id2 ld2 am2
Why does not deduce a line from the second group where columns are equal to NULL?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

V

vdem, 2014-09-25
@Diyahon

Maybe because comparing something with NULL is sort of pointless?
habrahabr.ru/post/127327