SQL Update多表联合更新的方法

oracle示例

update landleveldata a set (a.gqdltks, a.bztks)= (
    select b.gqdltks,
    b.bztks
    from gdqlpj b
    where a.GEO_Code=b.lxqdm
)

mysql示例

update landleveldata a, gdqlpj b
set a.gqdltks= b.gqdltks, a.bztks=b.bztks
where a.GEO_Code=b.lxqdm