Foxpro Translation to PL/SQL

From: MattLakers <Matt_Nguyen_at_yahoo.com>
Date: Fri, 23 Jul 1999 18:33:32 GMT
Message-ID: <0A2m3.427$_b.458970@dca1-nnrp1.news.digex.net>

Can anyone please show me how to translate FoxPro Query to a PL/SQL query, here is the FoxPro query that I am having touble with: Thank you very much!!!

Matt

SELECT A.DEPT,A.TY,A.SYMBOL,A.LIM,A.PO,A.GSN,A.AMS,A.MO,A.YR,;    SUBSTR(A.AMS,1,2), SUBSTR(A.AMS,5,1),;

   SUM(IIF(INLIST(TRC,"2E","2F"),AMT,0.00)),;
   SUM(IIF(TRC="1J",AMT,0.00)), SUM(IIF(TRC="1D",AMT,0.00)),;
   SUM(IIF(TRC="1K",AMT,0.00)),;
   SUM(IIF(INLIST(TRC,"1D,"1J","2E","2F"),AMT,IIF(INLIST(TRC,"1K"),AMT * -1,

0.0))),;

   FROM 218DATA A;
WHERE A.TRC IN ("2F","2E","1D","1J","1K");     AND SUBSTR(A.AMS,3,1) == "C";
    AND A.SYMBOL == "4930";
    OR (A.TRC IN("2F","2E","1D","1J","1K");    AND SUBSTR(A.AMS,7,1) == "C";
GROUP BY A.DEPT,A.TY,A.SYMBOL,A.PO,A.GSN,A.LIM,11,A.AMS,10; ORDER BY 10,11,A.PO,A.LIM,A.GSN,A.AMS,A.TY,A.SYMBOL; Received on Fri Jul 23 1999 - 13:33:32 CDT