将查询结果存储到另一个表中 [英] to store the results of a query into another table

问题描述

SELECT     course.Courseno,ids.PaperID
FROM         course CROSS JOIN
                      ids WHERE course.Courseno=ids.Courseno;

我想对此查询产生的表执行查询.

i want to perform a query on the table resulting from this query. Is it possible to to store the result in another table?

推荐答案

 Insert into TableName SELECT     course.Courseno,ids.PaperID
FROM         course CROSS JOIN
                      ids WHERE course.Courseno=ids.Courseno;

试试这个

with courseIdTemp (Courceno , PaperID) as
(
SELECT     course.Courseno,ids.PaperID
FROM         course CROSS JOIN
                      ids WHERE course.Courseno=ids.Courseno

)

Select * from courseIDTemp 

或

or

SELECT     course.Courseno,ids.PaperID
into CourceIDMix
FROM   course CROSS JOIN
                      ids WHERE course.Courseno=ids.Courseno
select * from CourceIDMix

朋友，

创建临时表并移动内容

快速概述:SQL Server 2005中的临时表 [ ^ ]

问候，
~~ Karthik.J ~~

friend,

create temporary table and move the content

Quick Overview: Temporary Tables in SQL Server 2005[^]

Regards,
~~Karthik.J~~

这篇关于将查询结果存储到另一个表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！