Oracle update with join in execute update jsp

Question

我想通过检查table1的column2和table1的column2来更新table2的table1。

我只是得到了缺少右括号的错误。

我只需检查两个表的ID (ID是另一个表的外键)，并检查来自查询字符串的激活码，如果它们匹配，我只需将status的值更新为approve

String s = "Approve";
stmt.executeUpdate("UPDATE  
                                   ( SELECT Approval.STATUS AS st 
                                       FROM Approval 
                                       JOIN Activity 
                                         ON Activity.userid = Approval.id 
                                      WHERE Activity.activationcode = 
                                           '"+activationcode+"') as up SET up.st = '"+s+"'");

Answer 1

将您的更新表字符串替换为以下内容，它应该可以正常工作

UPDATE 
 (SELECT 
    Approval.STATUS AS st 
  FROM 
    Approval JOIN Activity ON Activity.userid = Approval.id 
  WHERE 
    Activity.activationcode = '"+activationcode+"'
 ) up
SET up.st = '"+s+"'

在您的查询中，您正在尝试更新APPROVAL和UP表，这就是出现错误的原因