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