SQL Cross-table update

[a basket of rice special thin Original, reproduced please indicate from http://www.cnblogs.com/wanghafan/p/4384039.html]

Prerequisites: Two tables to update the field, the associated field structure is consistent

Update Library: FJPDI_TZGL

Extract Library: fjpdi_tzgl_29

Table: Datachangestempt

Update field: REASON

Associated field: IID

Goal: Update the datachangestempt reason field in fjpdi_tzgl_29 to datachangestempt field reason in Fjpdi_tzgl_

Query statement:

SELECT  from FJPDI_TZGL.dbo.DataChangesTempT SELECT  from Fjpdi_tzgl_29.dbo. Datachangestempt

UPDATE statement:

UPDATESET REASON =  d.reasonfrom WHERE   FJPDI_TZGL.dbo.DataChangesTempT.IID=

SQL Cross-table update