Got it!!!  Thank you~

Hi, Andy:

   Thanks for the reply. Really appreciate it! I generated the script of one database, then run the script generated in another database....

Hi, All:

   Thanks for sharing your answers~  I also think using the replace function is better and easier. Really appreciate your help

I was asked to make a report. The data source I got does not have any other IDs in the two tables. The only common thing they have is that...

Thanks for the information!

The space allocated for transaction log is the same. I guess the log will be shrinked from now on, but the old log remains the same.

Got it! It is my harddish running out of the space. The transaction log is way too big.   Will it deleted and repleaced...

Hi, John:

   Thank you for sharing the answer and the advise. I will try it!!

I just figired it out. The answer is:

select a.[name], a.Feb, b.March

from TABLE1 a left join TABLE2 b on a.[name] = b.[name]

union

select a.[name], b.Feb, a.March

from TABLE2 a left join...