select UI.UserTrueName,UI.UserDept,UI.UserSex,UM.* from UserInfo as UI,UserMatchMsg as UM
得到的结果为:UserInfo 表中的UserTrueName UserDept UserSex 字段 及UserMatchMsg 中所有字段s