回复讨论(解决方案) delete from (select * from sys_barcode_1d_y union all select * from sys_barcode_1d_y_bak union all select * from fg_hi_cust_in where hi_no like 'esc%') a where a.packageno='xxx'?
delete from (select * from sys_barcode_1d_y union all select * from sys_barcode_1d_y_bak union all select * from fg_hi_cust_in where hi_no like 'esc%')a where a.packageno='xxx'
delete from (select * from sys_barcode_1d_y union all select * from sys_barcode_1d_y_bak union all select * from fg_hi_cust_in where hi_no like 'esc%') a where a.packageno='xxx'?
感谢回答。但是是个语法错误，delete 不支持 union 表的删除，只能单表删除。