sybase中update

sjy345

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

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

baobaoly01

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

leoaikeer

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

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