SQL Inter-table columns are copied according to criteria (Assignment)

The columns of table two are updated to table one (same library, cross-Library), and the A and B tables are associated by field Empid. Requires that updates between the associated records need to be one by one corresponding to the relationship. The statements are as follows:

Update Set =  from where = Table Two. EMPID

To actually apply the SQL statement:

Update Crm.dbo.Crm_Project Set CRM: Crm_project.projectid= from crm.dbo.crm_project,pm. Project where CRM: Crm_project.prjcode=PM.. Project. Project number

SQL Inter-table columns are copied according to criteria (Assignment)