分布式事务seat对于sql语句的语法要求

昨天工作中，出现了一个系统异常

系统原因如下：

io.seata.common.exception.NotSupportYetException: not support the syntax of update with join table\n; uncategorized SQLException; SQL state [null]; error code [0]; io.seata.common.exception.NotSupportYetException: not support the syntax of update with join table; nested exception is java.sql.SQLException: io.seata.common.exception.NotSupportYetException: not support the syntax of update with join table"

io.seata.common.exception.NotSupportYetException: not support the syntax of update with join table\n; uncategorized SQLException; SQL state [null]; error code [0]; io.seata.common.exception.NotSupportYetException: not support the syntax of update with join table; nested exception is java.sql.SQLException: io.seata.common.exception.NotSupportYetException: not support the syntax of update with join table"

这个主要是因为sql中update语法出错
然后进行修正

这里要注意！！！需要用<set>    </set>

因为我在测试的时候一直在报错，badsql！尝试了上述方法得以解决