Wednesday 28 December 2016

Update one Table Column from other table column With Some Matching

UPDATE    SwachhAbhiyanSurvey

SET              Officer_id = t1.SRNo

FROM         officer_user AS t1 RIGHT OUTER JOIN

                      SwachhAbhiyanSurvey ON t1.GPAlloted = SwachhAbhiyanSurvey.PANCHAYAT_NAME

No comments:

Post a Comment