SELECT * FROM
(select distinct `vOpenID` as vopenid from t_PlayerRegister
where 1=1 and 1=1 and dtEventTimei+8*3600<1481817600 AND dtEventTimei>1481212800 and dtRegTimei+8*3600<1481817600 AND dtRegTimei>1481212800) as a
LEFT JOIN
(SELECT vopenid,COUNT(*) as num FROM t_PlayerRegister WHERE dtEventTimei+8*3600<1481817600 GROUP BY vopenid HAVING num>1) as b
ON a.vopenid = b.vopenid
mysql left join写法
最新推荐文章于 2024-06-26 18:31:47 发布