Subquery returned more than 1 value database query error

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$.