UPDATE with a SELECT - is it possible?

Is it possible to update a table with something like this:

UPDATE table1
(firstname,lastname)
SELECT 'newfirstname' as f, 'newlastname' as l
WHERE table1.personID = 5

or must one use something like:
UPDATE table1 SET field1 = 'xx', field2='yy' WHERE personID=5

I mean, can one update a range in a table with a range selected somewhere
else?



Jesper


.

Loading