SQL的多表子查询语句已经写好了,但是领导要我用kettle去代替SQL试试,为了让我熟悉KETTLE。意思就是用kettle的步骤去代替join,where。SQL代码如下,请问如何写KETTLE可以达到SQL查询出来的结果!!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), SUM(A.FTAXPRICE)/SUM(A.FREALQTY)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,步骤不知道对不对,不知道缺了什么,其中细节我也不知道怎么写。有没有人可以帮我指点一下KETTLE的步骤,需要用到哪些?