table A tok count a 1 b 1 table B tok count b 1 c 1 table C (desired) tok count a 1 b 2 c 1 #### INSERT INTO all_tok (tok, tok1.count+tok2.count) SELECT tok, count from tok1 UNION SELECT tok, count from tok2