写完这个SQL我要吐了

本帖最后由 sunrace2000 于 2010-12-11 03:25 编辑

sql "select   t0.jgcode, t8.ujgname ,sum( t0.zb100y) as zb100y       from   ( select    jgcode,zb100y from  t_plan where jgcode ='32048300' and plan_date='20101210'  union select  jgcode ,zb100y  from  t_plan  where jgcode in (select ujgm from t_jgm where udbjgm='32048300') and plan_date='20101210'  union select t3.ujgm as jgcode ,zb100y from t_plan as t1  join t_jgm as t2  on  t1.jgcode=t2.ujgm join t_jgm as t3 on t2.udbjgm=t3.ujgm where plan_date='20101210' and jgcode in (select ujgm from t_jgm  where ujgm in   (select  ujgm from t_jgm where udbjgm in (select ujgm from t_jgm where udbjgm='32048300')   )  ) union

select t7.ujgm as jgcode ,t4.zb100y from  t_plan as t4  join t_jgm as t5 on t4.jgcode = t5.ujgm  join t_jgm as t6 on t5.udbjgm=  t6.ujgm join t_jgm  as t7 on t6.udbjgm = t7.ujgm where t4.jgcode in (select ujgm from t_jgm where ujgm in(select ujgm from t_jgm where t4.plan_date='20101210' and  udbjgm in (select ujgm from t_jgm where udbjgm in (select ujgm from t_jgm where udbjgm='32048300' )) ))

) as t0  join t_jgm as t8 on   t0.jgcode=t8.ujgm  group by   t0.jgcode,t8.ujgname order by  t0.jgcode "

为啥要吐?