select UI.UserTrueName,UI.UserDept,UI.UserSex,UM.* from UserInfo as UI,UserMatchMsg as UM
得到的结果为：UserInfo 表中的UserTrueName UserDept UserSex 字段 及UserMatchMsg 中所有字段s
Sql合并查询两张表里的数据
一切尽在淘婚网www.taohunla.com
select UI.UserTrueName,UI.UserDept,UI.UserSex,UM.* from UserInfo as UI,UserMatchMsg as UM
得到的结果为：UserInfo 表中的UserTrueName UserDept UserSex 字段 及UserMatchMsg 中所有字段s