mysql对表中同一列统计_MySql View - 显示同一个表中另一列的数据

我有这个MySql视图定义(使用Navicat完成)：

SELECT DISTINCT

auctions.timelive AS timelive,

selections.id AS sel_id,

auctions.title AS `match`,

selections.title AS selection,

selections.odds AS odds,

auctions.bidprice AS bidprice,

(`auctions`.`bidprice` * (`selections`.`odds` - 1)) AS `next win rise`,

Sum((`auctions`.`bidprice` * (`selections`.`odds` - 1))) AS `pure winnings`,

selections.startamount AS startamount,

(sum((`auctions`.`bidprice` * (`bids`.`odds` - 1))) + `selections`.`startamount`) AS `winnings with startamount`,

bids.`timestamp` AS `last bid on`,

Max(bids.id) AS `highest bid id`

from (((`bids` join `selections` on((`bids`.`selectionid` = `selections`.`id`))) join `auctions` on((`bids`.`auctionid` = `auctions`.`id`))) join `users` on((`bids`.`userid` = `users`.`id`)))

GROUP BY

selections.id,

bids.auctionid

ORDER BY

`last bid on` ASC这是行得通的，但现在在最后一个'最高出价ID'列旁边想要在该视图'bids.userid'中获得更多列，这基本上就是'最高出价ID'列的右侧。

怎么做？ Canot找到解决方案！