连表更新

update t1 set t1.ndclicknum=t2.ndclicknum
from Novel_Book_LocalTmp t1 inner join Novel_Book t2 on (t1.bookid=t2.bookid)

 

 

 

update t1 set t1.cid=t2.cid
from novel_book_localtmp t1 inner join novel_bookcategory t2 on (t1.cname=t2.cname AND t1.fcid=t2.pid AND t1.siteid=22)