MS SQLserver mysql

 mysql: UPDATE order_comment   set  type_id=0 where    order_id in (select order_id from  (select order_id from order_comment where id=36 ) xx ) 

MS SQLserver:UPDATE order_comment   set  type_id=0 where    order_id in ( select order_id from order_comment where id=36  ) 
 update set  where select 组合语句不同数据库的SQL语句的区别