Helen Borrie wrote:

>No, it can't; but your first sub-select can return multiple rows and it's
>not permitted in a sub-select.
>
>heLen
>
>

Helen,

Please excuse my importunity. Could you explain how "select from table
where primary_key =" can return more than one row? Or advise me please
how to do such update?

Thank you.

Andrew