除了连接之外,有没有其他更快的更新方法?下面是我的查询,但有点慢: SET ExternalEmail = ud2.EmailINNER JOIN( AND Email IS NOT NULL AND LEN(Email) > 0ON ud1.UserName = ud2.UserName
谢谢你的任何想法
UPDATE FRA_SAPFROM FRA_SAP FES ON FES.ID = FE.IDjava.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properlyended
at oracle.jdbc.driver.T4CTTIoer.processE
这是我在MS Access中的工作查询...UPDATE Caxnode AS A INNER JOIN Caxnode AS B ON A.node_alias = B.node_alias WHERE (((A.node_mode)='virtual' Or (A.node_mode)='regular') AND ((B.partition_Type)='LDOM