delete asrsorderinfo.[订单编号] from asrsorderinfo left join midpatch3 on asrsorderinfo.[订单编号] = midpatch3.[订单编号]
------解决思路----------------------
--感觉你只是需要删除单列数据，delete from 之间不能加任何字段
update asrsorderinfo set [订单编号]='' from midpatch3 m3 where asrsorderinfo.[订单编号] = m3.[订单编号]