SQL select and update command

[Guan, Phillip]

Hi all,

Could someone give me an example how to do a select and then run command
against the select reqult? For example, I want:

Select volume_name from volumes where access!='READWRITE'
then
update volume the_result_from_select access=readwrite.

Thanks.

Best regards,
Phillip Guan