create view view_haiBaoAndUsers(haibaoID,nickname,headimgurl,dates,shared) as select haibao.ID,users.nickname,users.headimgurl,haibao.dates,haibao.shared from haibao,users where haibao.userID=users.ID