If you get an error message, please show it to us.
If you don't get an error message, then there is no record where assay matches your condition.
sql ignore the full update statement
This is not an update statement. It's a select statement. No data will be updated.
Regards, Jan