No it doesn't. I've now tested it. Here' my test:declare @t1 table (id tinyint, team char(1))declare @t2 table (id tinyint, team char(1))insert into @t1 values(1, 'x')insert into @t1 values(2, 'y')insert into @t1 values(3, 'z')insert into @t2 values(1, 'M')insert into @t2 values(3, 'N')select t1.id, team = case when t2.id is not null then t2.team else t1.team endfrom @t1 t1 left join @t2 t2on t1.id = t2.id
My query returns this:id team---- ----1 M2 y3 N
So something must be wrong with your data or your sample is wrong. Let me know.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog