Basic Select Statements 

static void CON_Select_Staements(Args _args)
{
    CustTable       custTable;
    CustTrans       custTrans;
    //container       con = ['DAT','RURT'];
    ;
    select sum(AmountMST) from custTrans group by custTrans.AccountNum ;
    print custTrans.AmountMST,custTrans.AccountNum;
    pause;
 
    /*while select reverse firstOnly10   custTable
    {
        info(strFmt('%1',custTable.AccountNum));
    }*/
 
    /*while select custTable
    {
     
    info('%1',custTable.AccountNum);
    }*/
    /*changeCompany('RURT')
    {
        custTable = null;
        while select custTable
        {
            info(strFmt("%1 - %2",custTable.AccountNum,custtable.CustGroup));
        }
    }  
    changeCompany('INMF')
    {
        custTable = null;
        while select custTable
        {
            info(strFmt("%1 - %2",custTable.AccountNum,custtable.CustGroup));
        }
    } */
     
         
 
    /*while select custTable notexists  join custTrans
        where custTable.AccountNum == custTrans.AccountNum
    {
        info(strFmt("%1 - %2",custTable.AccountNum,custtrans.AmountMST));
    }*/
 
     /* while select custTable exists  join custTrans
        where custTable.AccountNum == custTrans.AccountNum
    {
        info(strFmt("%1 - %2",custTable.AccountNum,custtrans.AmountMST));
    }*/
 
    /*while select custTable outer join custTrans
        where custTable.AccountNum == custTrans.AccountNum
    {
        info(strFmt("%1 - %2",custTable.AccountNum,custtrans.AmountMST));
    }*/
 
    /*while select custTable join custTrans
        where custTable.AccountNum == custTrans.AccountNum
    {
        info(strFmt("%1 - %2",custTable.AccountNum,custtrans.AmountMST));
    }*/
         
 
 
    /*while select AccountNum,CustGroup from custTable
        index hint accountidx
     
    {
        info(strFmt("%1 - %2",custTable.AccountNum,custTable.CustGroup));
    }*/
 
    /*while select custTable
        where custTable.CustGroup=="10"
    {
        info(strFmt("%1 - %2",custTable.AccountNum,custTable.CustGroup));
    } */
     
 
    /*while select AccountNum,CustGroup from custTable
        index party
    {
        info(strFmt("%1 - %2",custTable.AccountNum,custTable.CustGroup));
    }*/
     
    /*while select custTable
        order by AccountNum asc //desc
    {
        info(strFmt("%1",custTable.AccountNum));
    }*/
 
    /*while select minOf(AmountMST) from custTrans
        where custTrans.AccountNum == "US-002"
        //group by AccountNum
    {
        info(strFmt("%1 - %2",custTrans.AccountNum,custTrans.AmountMST));
    }*/
 
    /*while select maxOf(AmountMST) from custTrans
        group by AccountNum
    {
        info(strFmt("%1 - %2",custTrans.AccountNum,custTrans.AmountMST));
    }*/
    /*while select count(RecId) from custTrans where custTrans.AccountNum=="US-006"
    {
        info(strFmt("%1",custTrans.RecId,custTrans.AmountMST));
    }*/    
 
    /*while select avg(AmountMST) from custTrans
        group by AccountNum
    {
        info(strFmt("%1,' ',%2",custTrans.AccountNum,custTrans.AmountMST));
    }*/
 
    /*while select sum(AmountMST) from custTrans
        group by AccountNum
    {
        info(strFmt("%1,' ',%2",custTrans.AccountNum,custTrans.AmountMST));
    }*/
 
 
    /*ttsBegin;

    while select forUpdate custTable
        where custTable.AccountNum == "drtdthyugf"
    {
        custTable.AccountNum ='CH_006';
        custTable.update();
        info("update");
    }
    ttsCommit;*/

    /*while select firstOnly10 custTrans
    {
        info(strFmt("%1,%2",custTrans.AccountNum,custTrans.AmountMST));
    }*/

    /*while select firstFast custTable
    {
        info(strFmt("%1,%2",custTable.name(),custTable.nameAlias()));
    }*/

    /*while select firstOnly custTable
    {
        info(strFmt("%1,%2",custTable.name(),custTable.nameAlias()));
    }*/

    /*select firstOnly custTable;
    info(strFmt("%1,%2",custTable.CustGroup,custTable.RecId));*/

    /*select reverse custTable;
    info(strFmt("%1,%2",custTable.AccountNum,custTable.name()));*/

    /*select crossCompany:con custTable;
    info(strFmt("%1,%2",custTable.AccountNum,custTable.Currency));*/

    /*select * from custTable;
    info(strFmt("%1,%2",custTable.AccountNum,custTable.Currency));*/

   /*while select CustAccount from salesTable
        group by SalesId,CustAccount
        where salesTable.CustAccount == "us-001"
        && salesTable.SalesStatus   == SalesStatus::Backorder
        join sum(LineAmount),SalesId from salesLine      
        where salesLine.SalesId  == salesTable.SalesId
   {
    info(strFmt("%1--%2--%3",salesTable.CustAccount,salesTable.SalesId,SalesLine.LineAmount));
       
    }*/

/*while select ct group by ct.CustGroup  join sum(AmountMST) from ctr
        where ct.AccountNum == ctr.AccountNum
        {
        info(strFmt("%1   %2",ct.CustGroup,ctr.AmountMST));
       }*/

}