Search results

I need to update a table using a query to reference the the records to be updated. The problem is that on the table there might be multiple record of the instance I need to update. I need to update just one and change it's status to SALE. I use a select query to retrieve a single record; this...