I will like to combine rows two different tables. Only rows which have equal fields in the first colunm should be added. see illstration below
Combining table A and B should give the following result
1 a g
2 b f
4 d h
let me know if you need forward expalination.