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

这样行不？
update bbs1
set nickname=user.userpassword
from user
where bbs1.username=user.username

不过nickname=password?