SQL statement does not execute 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'
Reply to discussion (solution)
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 '?
Thank you for your answers. However, this is a syntax error. delete does not support the deletion of union tables. it can only be deleted from a single table.