ORACLE 多表关联 UPDATE 语句

UPDATE TBL_POWER_BILL A
SET A .PB_EI_STATUS = '已开',
 (
	A .PB_EI_FILE,
	A .PB_INVOICE_CODE
) = (
	SELECT
		b.EIFILE,
		b.ETL_FPHM
	FROM
		TBL_EI_TASK_LOG b
	WHERE
		b.ETL_FPQQLSH = A .PB_FPQQLSH
)
WHERE
	EXISTS (
		SELECT
			1
		FROM
			TBL_EI_TASK_LOG b
		WHERE
			b.ETL_FPQQLSH = A .PB_FPQQLSH
	)
AND A .PB_EI_STATUS = '未开'

转载于:https://my.oschina.net/u/1385936/blog/1814249