[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.
Cheers
mk
More information about the thelist
mailing list