是的，你可以像下面这样使用CREATE TABLE AS ... SELECT FROM结构;考虑到new_table并不存在

create table new_table as
SELECT * from tablepeople 
join tableinfo 
on tablepeople.id = tableinfo.ctrlid

编辑：

根据最新的评论，使用表别名来解决这个问题

CREATE TABLE mytable3 AS
SELECT t1.* 
  FROM mytable1 t1
    JOIN mytable2 t2 ON t1.ID=t2.ID

您可以使用
新建表new_table

Create table new_table as
SELECT * FROM customers
LEFT JOIN orders ON customers.idcustomers = orders.idorders
UNION
SELECT * FROM customers
RIGHT JOIN orders ON customers.idcustomers = orders.idorders;

此查询将连接两个表并使用这两个连接的表创建新表

Syntex: select * into new_table_name
From table1 as t1
Join table2 as t2 ON t2.column name = 
t1.column name;


Example: select * into emp_detls
From employee as emp
Join employeeDOB AS edob ON edob.employeeID 
= emp.e_id

CREATE TEMPORARY TABLE [table_name] ( [query] );

或

CREATE TABLE [table_name] ( [query] );