来自内部联接查询错误的更新集 [英] update set from inner join query thowing error

问题描述

我想运行如下查询:

UPDATE   I
SET I.CAP_NAME =  S.CAP_NAME 
FROM INSURED_FARMERS  I 
INNER JOIN INDIAN_STATES_REGION  S 
   ON UPPER(I.STATE_NAME_FI) = UPPER(S.STATE_NAME)

但它引发错误:sql错误ora-00933 sql命令未在行上正确结束: SET I.CAP_NAME = S.CAP_NAME

but it throws an error: sql error ora-00933 sql command not properly ended on line: SET I.CAP_NAME = S.CAP_NAME

推荐答案

请参见此处: stackoverflow

您可以同时使用两种方法:

you can do both ways:

1. 就像答案存在一样
2. 如果表通过具有唯一索引或主键的列(这些列UPPER(I.STATE_NAME_FI) = UPPER(S.STATE_NAME))连接，则使用内联视图

1. like there is an answer with exists
2. using inline view if your tables are connected by the columns with unique indexes or primary keys (these columns UPPER(I.STATE_NAME_FI) = UPPER(S.STATE_NAME))

这篇关于来自内部联接查询错误的更新集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！