[thelist] Null values in where clauses in SQL Server

[Mike King]

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.

Cheers
mk