Browse by Tags

All Tags » NULL and joins (RSS)
24 December 2008 10:24

NULL on joined columns

You know that NULL values on joined columns are omitted from comparision when tables are joined Consider this example Declare @t1 table ( col1 int , col2 varchar ( 10 )) insert into @t1 select 1 , 'test1' union all select 2 , 'test2' union...
Posted by Madhivanan | with no comments
Filed under: , ,