（1）select * from A表 where column_1 not in (select column_1 from B表)（2）select case when b.column_2 a.column_2 then b.column else null end as column_2,后面的字段 from 表B as bleft join 表A aon a....
SQLServer 用脚本比较两表差异。正确答案追加分。
（1）select * from A表 where column_1 not in (select column_1 from B表)（2）select case when b.column_2 a.column_2 then b.column else null end as column_2,后面的字段 from 表B as bleft join 表A aon a....