通过kettle代替SQL代码去进行子查询,输出的结果要达到SQL的查询结果。SQL代码如下,在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
------------------------------------------------------------------------------------------ 我想问一下,我这样写有没有问题,具体细节我还没写,步骤是这样对吗?按我SQL的语句来的话,kettle里面步骤
|