要将 "insert into ... with A as (查询)，B as (查询)" 这样的插入数据语句改为查询语句，您需要使用 SELECT 语句来执行相应的查询操作。

假设您的原始插入语句如下：

sql复制代码

INSERT INTO table_name (column1, column2, ...)  

WITH A AS (SELECT * FROM another_table WHERE condition1),  

B AS (SELECT * FROM another_table WHERE condition2)  

SELECT A.column1, B.column2, ...  

FROM A

INNER JOIN B
ON A.columnX = B.columnY;

要将此插入语句转换为查询语句，您可以执行以下操作：

sql复制代码

INSERT INTO table_name (column1, column2, ...)  
SELECT A.column1, B.column2, ...  

FROM (SELECT * FROM another_table WHERE condition1) AS A  

INNER JOIN (SELECT * FROM another_table WHERE condition2) AS B  

ON A.columnX = B.columnY;

这将返回与原始插入语句相同的结果。