UNION ALL不适用于6个不同数据库的多个单独查询

My goal is to insert the results of the 6 individual scripts into a table, it is separated into 6 because it uses different Databases. I used UNION ALL to combine all results and insert into a newly created table. I have done this before and it became successful. Below is the example that I have done this successfully before.My goal is to insert the results of the 6 indiv