用KETTLE代替SQL代码进行子查询。

Question

由于KETTLE不是很熟练，很多连接转换不知道用哪个。

SELECT  YEAR(DATEADD(mm, -1, GETDATE()))as FYEAR,
        MONTH(DATEADD(mm, -1, GETDATE()))AS FMONTH,
        A.FLOT,
         A.FLOT_TEXT,
        A.FNUMBER,
        A.FOLDNUMBER,
        SUM(A.FREALQTY)[FREALQTY],
        SUM(A.FTAXPRICE)/SUM(A.FREALQTY)[FTAXPRICE]
FROM  (SELECT    TSI.FLOT,
                TSI.FLOT_TEXT,
                TBM.FNUMBER,
                TBM.FOLDNUMBER,
                TSI.FREALQTY,
                TF.FTAXPRICE
        FROM     T_STK_INSTOCKENTRY TSI 
                LEFT JOIN T_STK_INSTOCK TS ON TSI.FID=TS.FID
                LEFT JOIN T_BD_MATERIAL TBM ON TSI.FMATERIALID=TBM.FMATERIALID
                LEFT JOIN T_STK_INSTOCKENTRY_F TF ON TSI.FENTRYID=TF.FENTRYID
        WHERE  EXISTS(SELECT    TAO.FLOT 
                        FROM     T_AR_RECEIVABLEENTRY_O TAO 
                                    LEFT join T_AR_RECEIVABLE TR ON TAO.FID=TR.FID 
                           WHERE   TAO.FLOT=TSI.FLOT 
                                    AND TAO.FLOT!='' 
                                    AND DATEDIFF(mm, TR.FDATE, GETDATE())=1) 
                AND TSI.FLOT!='' 
                AND TS.FCANCELSTATUS='A' 
                    AND TS.FDOCUMENTSTATUS='C')A 
GROUP BY A.FLOT,A.FLOT_TEXT,A.FNUMBER,A.FOLDNUMBER

需要我用KETTLE讲每个表的字段筛选出来，代替SQL进行子查询，有没有YYDS知道步骤应该是什么。

Answer 1

经过不懈努力，自己摸索出来了。这社区废了，没悬赏就没人理的