UPDATE TBL_GOODS SET G_MODEL = (SELECT GR_NAME FROM TBL_GROUPS WHERE GR_ID = G_GR_ID) WHERE ISNULL(G_MODEL, '') = ''