sql 语句不执行
程序员文章站
2022-06-11 19:46:10
...
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 packageno='xxx'
感谢回答。但是是个语法错误,delete 不支持 union 表的删除,只能单表删除。
回复讨论(解决方案)
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 表的删除,只能单表删除。