One of my tests used a query to select records into a temp table and then a second query to further refine the results from the temp tables.

我的一个测试中使用了一个查询，该查询将一些记录挑选出来放入一个临时表中，然后另一个查询将进一步筛选临时表中的结果。

youdao

Where; you select the columns of interest from rows in a table or tables where certain conditions are satisfied.

您可以从一个或多个表的行中选择您感兴趣的满足特定条件的列。

youdao

Now, when the same query is run, the native SQL that is generated is a single select statement joining the two tables from the different catalogs at the database tier as shown in Illustration 10.

现在，当同一个查询运行时，生成的原生s QL是单个选择语句，在语句在数据库层联接来自不同目录的两个表，如图10所示。

youdao