Hi wenny,

you can also use a full outer join like this

SELECT  distinct   CASE  ISNULL( t2.[name],'') 

When '' THEN  t1.[name]

else t2.name  

end AS name, t1.feb, t2.March

FROM         t1 full OUTER join

                      t2 on t1.name = t2.name

you should compare speed if the two tables are large.

Cheers,

John R. Hanson