sql语句:比较两个表中的两列,找出a表中A列中有而b表中a列中没有的数据,并添加到c

Answer 1

insert into c values(select a.* from a where a.A not in (select b.a from b) and a.A is not null)