[Axapta-Knowledge-Village] What is the quivalent X++ statement for SQL statement

[padmaja_wipro]

update custsettlement 

      set accountnum =  

            (select accountnum from custtrans 

            where dataareaid='DAT'

                  and recid=custsettlement.transrecid

            and ltrim(rtrim(accountnum))=ltrim(rtrim
(custsettlement.accountnum)))

      where dataareaid='DAT'

      and ltrim(rtrim(accountnum))='1'

         and transrecid in

            (select recid  from  custtrans 

            where dataareaid='DAT'

                             and recid=custsettlement.transrecid

                        and ltrim(rtrim(accountnum))<>ltrim(rtrim
(custsettlement.accountnum)))



thank you so much

-Padmaja