ksql 分组子查询问题

lihua123

select tt.ITEM_NAME as NAME1,ttt.ITEM_NAME as NAME2,t.PROJECT_NAME as NAME3,SQL.wmsys.wm_concat(PJ.PROJECT_QUALITY) as NAME4
    from TableItem tt optional
    join TableItem ttt on 1 = 1 optional
    join T_PROJECT t on tt = t.PROJECT_CATETORY AND ttt = t.PROJECT_TYPE optional
    join T_PROJECT_TREAD PT on t = PT.T_PROJECT_ID optional
    join T_PROJECT_WEEKREPORT PJ on PT = PJ.T_PROJECT_TREAD_ID
    join TableData a on tt.T_CODETABLE_DATA_ID = a
    join System b on a.T_CODETABLE_SYSTEM_ID = b
    join TableData aa on ttt.T_CODETABLE_DATA_ID = aa
    join System bb on aa.T_CODETABLE_SYSTEM_ID = bb
    where b.SYSTEM_CODE = 'PMS' AND a.DATA_CODE = 'PROJECT_TYPE' AND bb.SYSTEM_CODE = 'PMS' AND aa.DATA_CODE = 'PROJECT_CLASSIFY'
    group by tt.ITEM_NAME, ttt.ITEM_NAME, t.PROJECT_NAME

select h.NAME1 as cc,h.NAME2 as dd from (
select tt.ITEM_NAME as NAME1,ttt.ITEM_NAME as NAME2,t.PROJECT_NAME as NAME3,SQL.wmsys.wm_concat(PJ.PROJECT_QUALITY) as NAME4
    from TableItem tt optional
    join TableItem ttt on 1 = 1 optional
    join T_PROJECT t on tt = t.PROJECT_CATETORY AND ttt = t.PROJECT_TYPE optional
    join T_PROJECT_TREAD PT on t = PT.T_PROJECT_ID optional
    join T_PROJECT_WEEKREPORT PJ on PT = PJ.T_PROJECT_TREAD_ID
    join TableData a on tt.T_CODETABLE_DATA_ID = a
    join System b on a.T_CODETABLE_SYSTEM_ID = b
    join TableData aa on ttt.T_CODETABLE_DATA_ID = aa
    join System bb on aa.T_CODETABLE_SYSTEM_ID = bb
    where b.SYSTEM_CODE = 'PMS' AND a.DATA_CODE = 'PROJECT_TYPE' AND bb.SYSTEM_CODE = 'PMS' AND aa.DATA_CODE = 'PROJECT_CLASSIFY'
    group by tt.ITEM_NAME, ttt.ITEM_NAME, t.PROJECT_NAME) h
group by h.NAME1,h.NAME2

难道ksql不能嵌套查询分组吗

wangliang

复杂的语句可以用sql查询