UPDATE from SELECT

Under most circumstances, SQL updates are performed using direct referencesto a particular table (UPDATE books SET books.title = 'The Hobbit' WHERE books.id = 1). Yet, on occasion, it may prove beneficial…