联表约束修改数据

-- update 表别名 set xx=val from 别名表 联结 别的表 关联 字段条件 where 约束条件
update o set platno = null,paytime = null,updatetime=null
from [t_direct_order] o 
left join [t_direct_order_airline] f with(index = i_oid,index=i_onlypnradt) on o.id = f.oid
where (1=1)
and f.onlypnradt = 'Q32ELP';