下面语句有错，我是才鸟，请高手多指教：
update bbs1
set bbs1.NickName=(select user.UserPassword from user,bbs1 where bbs1.UserName= user.UserName);