1.select uname, (select password from users a where a.username=b.uname ) as pwd from B_Enterprise b
2.update yidihr.dbo.college set baifangtime = (select top 1 addTime from tripjdrc.dbo.contract where uname=username order by addTime desc)
3.select usersMessage.*,company.cname from usersMessage left join company on usersMessage.userid = company.userid