SQL statement does not execute

Delete from (SELECT * To sys_barcode_1d_y UNION ALL SELECT * FROM Sys_barcode_1d_y_bak UNION ALL SELECT * FROM Fg_hi_cus t_in where hi_no like ' esc% ') a where packageno= ' xxx '

Reply to discussion (solution)

Delete from (SELECT * To sys_barcode_1d_y UNION ALL SELECT * FROM Sys_barcode_1d_y_bak UNION ALL SELECT * FROM Fg_hi_cus t_in where hi_no like ' esc% ') a where a.packageno= ' xxx '?

Delete from (SELECT * To sys_barcode_1d_y UNION ALL SELECT * FROM Sys_barcode_1d_y_bak UNION ALL SELECT * FROM Fg_hi_cus t_in where hi_no like ' esc% ') a where a.packageno= ' xxx '

Delete from (SELECT * To sys_barcode_1d_y UNION ALL SELECT * FROM Sys_barcode_1d_y_bak UNION ALL SELECT * FROM Fg_hi_cus t_in where hi_no like ' esc% ') a where a.packageno= ' xxx '?

Thanks for the answer. However, it is a syntax error, and delete does not support the deletion of union tables, only single-table deletions.

