a表字段:o_id,c_id,[date] b表字段:o_id,c_id,[date],...其它字段 要把b表中在a表o_id,c_id,[date]都不存在(o_id,c_id,[date]是a表的联合主键)的行,插入到a表的sql语句怎么写?insert into a select o_id,c_id,[date] from b where cast(a as varchar) + cast(b as varchar) + cast([date] as varchar) not in (select cast(a as varchar) + cast(b as varchar) + cast([date] as varchar) from a)
insert into a select o_id,c_id,[date] from b where o_id not in (select o_id from a) and c_id not in(select c_id from a) and date not in(select date from a)
b表字段:o_id,c_id,[date],...其它字段
要把b表中在a表o_id,c_id,[date]都不存在(o_id,c_id,[date]是a表的联合主键)的行,插入到a表的sql语句怎么写?insert into a
select o_id,c_id,[date] from b where cast(a as varchar) + cast(b as varchar) + cast([date] as varchar) not in (select cast(a as varchar) + cast(b as varchar) + cast([date] as varchar) from a)
select o_id,c_id,[date] from b where o_id not in (select o_id from a) and c_id not in(select c_id from a) and date not in(select date from a)