如何mysql合并两表

Question

合并两表
select a.kmmxbh,a.kmmxname from v_kjkm a

select b.kmmxbh as kmbh,b.kmmxname as kmname from v_kmmx b;

Answer 1

SELECT kmmxbh, kmmxname FROM v_kjkm
UNION
SELECT kmbh, kmname FROM v_kmmx;