|
UPDATE RP_bankrecp SET RP_bankrecp.iflag = rp_bankrecp_2011.iflag FROM RP_bankrecp LEFT JOIN RP_bankrecp_2011 ON RP_bankrecp.i_id = RP_bankrecp_2011.i_id update table1 set table1.field1=table2.field2 from table1 left join table2 on table1.fieldX=table2.fieldy |