SQL update select结合语句

正确的

UPDATE "his_system_medcine_frequency" A
SET A ."input_code" = (
    SELECT
        b.INPUT_CODE
    FROM
        COM_DICTIONARY b
    WHERE
        TYPE = 'YBTS.FreCompare'
and     A ."frequency_code" = b.CODE
)

错误的

UPDATE "his_system_medcine_frequency" A
SET A ."input_code" = (
    SELECT
        b.INPUT_CODE
    FROM
        COM_DICTIONARY b
    WHERE
        TYPE = 'YBTS.FreCompare'
)
WHERE
    A ."frequency_code" = b.CODE

这样b.CODE 会出现 ORA-00904: “B”.”CODE”: invalid identifier标识符错误

参考博客：https://www.cnblogs.com/felix-wang/p/6742980.html

1 --------(MS SQL Server)语句：
2 update b   set   ClientName    = a.name    from a,b    where a.id = b.id  
3 
4 --------(Oralce)语句：
5 update b   set   (ClientName)    =   (SELECT name FROM a WHERE b.id = a.id)