需求: oracle
BH_MD 字段为空时,把COMPLETION_MD 字段设置到x1上
UPDATE (
SELECT
A.BH_MD mj1,
B.COMPLETION_MD mj2
FROM
SOURCE_A1 A,
SOURCE_A1 B
WHERE
A.WELL_ID = B.WELL_ID
AND a.BH_MD IS NULL
AND b.BH_MD IS NULL
) C
SET C.MJ1 = C.MJ2;
需求: oracle
BH_MD 字段为空时,把COMPLETION_MD 字段设置到x1上
UPDATE (
SELECT
A.BH_MD mj1,
B.COMPLETION_MD mj2
FROM
SOURCE_A1 A,
SOURCE_A1 B
WHERE
A.WELL_ID = B.WELL_ID
AND a.BH_MD IS NULL
AND b.BH_MD IS NULL
) C
SET C.MJ1 = C.MJ2;