SQL文が実行されない

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 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'?