if not exists (select columnname1,columnname2 from tablename1)
insert into tablename1 (columnname1,columnname2.....)
select columnname1,columnname2,...... fromtablename2
else Update tablename1 Set
insert into tablename1 (columnname1,columnname2.....)
select columnname1,columnname2,...... fromtablename2
else Update tablename1 Set
columnname1= (Select columnname1fromtablename2 where tablename1.columnname=tablename2.columnname)
如果遇到不能识别由多个绑定的某字段时,可以试试加入视图和关联。