UPDATE "DCS_SB_DATA_RECORD"
SET "SB_ORG_ID" = (SELECT "ORG_ID" FROM "DCS_POSITION" WHERE "DCS_SB_DATA_RECORD"."SB_DATA_ID" = "DCS_POSITION"."ID");
//DCS_SB_DATA_RECORD 需要更新的表
//DCS_POSITION 从哪表找数据的表
UPDATE "DCS_SB_DATA_RECORD"
SET "SB_ORG_ID" = (SELECT "ORG_ID" FROM "DCS_POSITION" WHERE "DCS_SB_DATA_RECORD"."SB_DATA_ID" = "DCS_POSITION"."ID");
//DCS_SB_DATA_RECORD 需要更新的表
//DCS_POSITION 从哪表找数据的表