update tablea set tablea.name=tableb.name from tableb where tablea.id=tableb.id 转载于:https://www.cnblogs.com/andylaufzf/archive/2011/06/27/2091153.html