[thelist] Null values in where clauses in SQL Server

Mike King mike.king at redroom.co.uk
Fri Mar 15 10:15:08 CST 2002

At 10:13 15/03/02 -0500, Ben Gustafson said:

>After examining the rows brought back by the queries, it becomes apparent
>that the first query was excluding not only the rows where the record_type
>is 2, but also where the record_type is null. I may fashion this into a tip
>after getting input from thelist.

You can sort that out by using a left join instead of a join.


More information about the thelist mailing list