Question

Subquery returned more than 1 value database query error

  • 5 April 2024
  • 0 replies
  • 60 views

Badge +6

Hi.. I am getting below query error during database execution.

 

Error - Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression automation anywhere a360 error.

 

Query - UPDATE [Sheet1$$] SET [Status] = '$intCRMIncidentRequest$' WHERE UCase(Trim([Description])) LIKE '%$intReferenceNumber$%' AND UCase(Trim([Cr_Dr]))='CR' AND [Transaction_Amount] = $intAmount$.


0 replies

Be the first to reply!

Reply