oracle with as 用法

来源：互联网发布：苹果库存监控软件编辑：程序博客网时间：2024/05/16 14:50

with tmp_0042 as (SELECT     F003D_0042,    F008V_0042,       F007N_0042,    F006B_0042,    OB_RECTIME_0042,    OB_TEXTID_0042,    F002D_0042,    F004V_0042 FROM TB_TEXT_0042     WHERE TO_CHAR(OB_RECTIME_0042, 'yyyy-MM-dd') = '2013-01-04' )--select * from tmp_0042SELECT D.*, E.F006B_0042FROM    (SELECT    F003D_0042,    F008V_0042,        F007N_0042,    OB_RECTIME_0042,    OB_TEXTID_0042,    F002D_0042,    F004V_0042,    WM_CONCAT(B.OB_SECCODE_0045),    B.F001V_0045,    WM_CONCAT(C.OB_SORTCODE_0043)    FROM    tmp_0042 A,    TB_TEXT_0045 B,    TB_TEXT_0043 C    WHERE    A.OB_TEXTID_0042=B.OB_TEXTID_0045    AND A.OB_TEXTID_0042 =C.OB_TEXTID_0043    AND F001V_0045 IN ('QDII',                        'LOF',                        'ETF',                        '老基金',                        '开放式基金',                        '封闭式基金')    GROUP BY F003D_0042,    F008V_0042,        F007N_0042,    OB_RECTIME_0042,    OB_TEXTID_0042,    F002D_0042,    F004V_0042,        B.F001V_0045    ) D,     tmp_0042 E WHERE D.OB_TEXTID_0042 = E.OB_TEXTID_0042

0 0