Merge two tables

[Anonymous]

Hi All,

I have two tables say Tab1 and Tab2 and I want result as Tab3. What is the most efficient way to do it on large data set.

Tab1:

Date          Type          Amount

1/31/12      A                    0

2/29/12      A                    0

3/31/12      A                    0

1/31/12      B                    0

2/29/12      B                    0

3/31/12      B                    0

Tab2:

Date          Type          Amount

1/31/12      A                    10

2/29/12      A                    20

2/29/12      B                    50

Tab3(Result Table):

Date          Type          Amount

1/31/12      A                    10

2/29/12      A                    20

3/31/12      A                      0

1/31/12      B                      0

2/29/12      B                    50

3/31/12      B                      0

Thanks in advance..

BR,

SAK