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,
`commodity` varchar(255) NOT NULL,
`class` varchar(255) NOT NULL,
`price` double NOT NULL,
`jifen` double(11,2) NOT NULL,
`stoptime` datetime NOT NULL,
`stopprice` double default '0',
`js` double(11,2) default NULL,
`state` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=gb2312;
32) NOT NULL,
`lx` int(11) NOT NULL,
`name` varchar(20) NOT NULL,
`sex` char(1) NOT NULL,
`phone` char(11) NOT NULL,
`phonev` char(1) default NULL,
`email` varchar(50) NOT NULL,
`emailev` char(1) default NULL,
`regtime` datetime NOT NULL,
`regip` varchar(255) NOT NULL,
`jifen` double(11,2) NOT NULL default '0.00',
`je` double(11,2) NOT NULL default '0.00',
`viptime` datetime default NULL,
`tj` int(11) default NULL,
PRIMARY KEY (`id`,`username`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=gb2312;
CREATE TABLE `pricemsg` (
`name` varchar(255) NOT NULL,
`label` varchar(255) NOT NULL,
`class` varchar(255) default NULL,
`win` int(3) NOT NULL default '85',
`loss` int(3) NOT NULL default '15',
`price` double default NULL,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
展开