我行云流水

update 表1 set flag='d' from 表2 where pay like '%货到付款%';

执行sql语句时，出现错误，请问哪里出错了。
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from 表2 where pay like '%货到付款%'' at line 1

成龙之龙

from 表2 where pay like '%货到付款%';

山东绿环动力

你看看你有没有多余的标点符号