关于sql的问题——sql未正确结束

Question

update xfdjb s
set s.transactor =
(select t.fullname from xc_user t where t.username = 'wany')||',yu'
where s.yw_guid = '23e3e467-147e8ccaf3d--7f9f'
总是报错，也看不出来，求教....

Answer 1

写成下面这样

update xfdjb s
set s.transactor =
(select t.fullname || ',yu' from xc_user t where t.username = 'wany')
where s.yw_guid = '23e3e467-147e8ccaf3d--7f9f'