SELECTd.*,pm.label,(SELECTCOUNT(*)from(selectjs,jifenfromdealwhereuid=m.idandtime>DATE_FORMAT(time,'$Y-$d-$m')andstate!=1andstate!=6GROUPBYstoptime)asjys)fromdealasd,memb...
SELECT d.*,pm.label,(SELECT COUNT(*) from (select js,jifen from deal where uid=m.id and time>DATE_FORMAT(time,'$Y-$d-$m') and state!=1 and state!=6 GROUP BY stoptime) as jys) from deal as d,members as m,pricemsg as pm where d.state<>1 and d.uid=m.id and d.time>DATE_SUB(now(),INTERVAL 1 MONTH) and m.username='111111111' and m.lx=1 and pm.name=d.commodity order by d.id desc
必须需要那个语句，怎么在子查询(select js,jifen from deal where uid=中等于m.id的置，求解！
CREATE TABLE `deal` (
`id` int(11) unsigned zerofill NOT NULL auto_increment,
`uid` int(11) NOT NULL,
`time` datetime NOT NULL,
`type` int(11) NOT NULL