✅ 看你图中的sql，没有发现表 aa，请检查！

语法：

insert into <tableName1>[(<table_column1>,<table_column2>...)] 
   select [<column_value1>,<column_value2>...] from <tableName2> [where [...]]
   union [ select [<column_value1>,<column_value2>...] from <tableName2> [where [...] ]]

请参考以下：

SQL> create table lucifer(id number,name varchar2(200));

Table created.

SQL> insert into lucifer(id,name) select 1,'a' from dual;

1 row created.

SQL> insert into lucifer(id,name) select 1,'a' from dual union all select 2,'b' from dual;

2 rows created.

SQL> insert into lucifer(id,name) select b.* from (select 1,'a' from dual union all select 2,'b' from dual) b;

2 rows created.

SQL> commit;

Commit complete.

希望能帮助到你~