ksql语句报错

andyl

select d.fprovince,d.fcity,f.fpaynum,d.factivitynum,round((d.factivitynum/f.fpaynum)*100,2) as fap from     (select c.fprovince,c.fcity,count(c.fphone) as factivitynum from (select * from (select a.fcode,SUBSTRING(a.factivity,INSTR(a.factivity,'-')+1) as factivity,count(a.fresult) as num  from (select * from FI_activity where fresult='已通过' ) a group by a.fcode having num>0 )FI_activity optional join FI_User FI_User on FI_activity.fcode =FI_User.fphone)c  group by c.fprovince,c.fcity)d optional join
(select e.fprovince,e.fcity,count(e.fphone) as fpaynum from (select * from FI_User FI_User optional join (select a.fcode,SUBSTRING(a.factivity,INSTR(a.factivity,'-')+1) as factivity,count(a.fresult) as num  from (select * from FI_activity where fresult='已通过'  ) a group by a.fcode having num>3  )FI_activity on FI_User.fphone=FI_activity.fcode)e  group by e.fprovince,e.fcity)f
on d.fcity=f.fcity

用的ksql,是不是select *,不能用* 啊!

andyl

已经解决了,结贴吧