sybase中update

[Soarin]

update cource set teacher_name = teacher.name where cource.teacher_id = teacher.id

这种update操作sybase都不支持吗?

[hobbylu]

支持的

[truelie123]

update cource set teacher_name = teacher.name from teacher where cource.teacher_id = teacher.id

[jxym001]

update cource a
set (teacher_id ,teacher_name) =
(select
b.teacher_id ,b.teacher_name
from student b
where 条件1
)
where 条件2

这种语句在sybase 里面怎么处理啊?