Question

SQL ：a ,b两张表结构相同，要将a,b的内容复制到表c.

如果表a.name = b.name，则只复制表a的该列到表c，如何用SQL写？
如果a.name != b.name，则还需要将b表对应行复制到c

Answer 1

insert into c
(select *
from a
union all
select * from b where b.name not in (select a.name from a))

Answer 2

insert into c select t0.XX from a t0 ,b t1 where t0.name = t1.name
insert into c select t1.XX from a t0 ,b t1 where t0.name <>t1.name

Answer 3

insert into c
select a.* from a,b where a.name = b.name

Answer 4

insert into c
(select * from a
union
select * from b
where not exists (select 1 from a where a.name=b.name )