Syntatical Error while using the Update with Select Query

  • 4 August 2022
  • 1 reply

Hi Everyone,

I am trying to use the update query with select statement in automation anywhere. I have 2 different tables(2 excel sheets). I need to update one column by comparing the colum names [client num]of first table with RAFT Client # column in the second table. 

If the client value matches, then bot needs to update optin column

For this I have used the Insert/Update/Delete Command, and i used the below query :


UPDATE [ASO Output$] SET [ASO Output$.Opt In?]=[Sheet1$.Max_ASO Vendor Fee Pass Through] FROM (SELECT [Sheet1$.Max_ASO Vendor Fee Pass Through],[Sheet1$.RAFT Client #] FROM[Sheet1$] AS [Sheet1$] WHERE [SHEET1$.RAFT Client #]=[ASO Output$.CLient_Number];


But I can't able to get the proper result, Syntatical error occured. Can anyone help me to resolve this issue



Gayathri M


1 reply

Userlevel 6
Badge +9

Hi @Gayathri M​ ,


Good Day!


Please refer the below KB article for the reported error and follow the steps:>>


If you are still facing an issue then please create a support case


How to create a support case :>

if you don't have access to the above link, email the AA Support team "" to get the access.