这个查询的语法有问题吗? [英] wats wrong with the syntax of this query?

问题描述

SELECT     subject.PaperName, subject.Marks
FROM         course INNER JOIN
                      ids ON course.Courseno = ids.Courseno INNER JOIN
                      subject ON ids.PaperID = subject.PaperID
                      INTO result;

消息156，第15级，状态1，第5行
关键字"INTO"附近的语法不正确.
这是我得到的错误.我基本上想将查询结果存储到新表中.

Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword ''INTO''.
This is the error I am getting. I basically want to store the result of the query into a new table.

推荐答案

尝试以下操作:

1.

Try this:

1.

SELECT subject.PaperName
	 , subject.Marks
FROM
	course
	INNER JOIN
		ids
		ON course.Courseno = ids.Courseno
	INNER JOIN
		subject
		ON ids.PaperID = subject.PaperID
                      INTO TABLE result;

2.

 INSERT INTO result
SELECT subject.PaperName
	 , subject.Marks
FROM
	course
	INNER JOIN
		ids
		ON course.Courseno = ids.Courseno
	INNER JOIN
		subject
		ON ids.PaperID = subject.PaperID

3.

3.

SELECT subject.PaperName
	 , subject.Marks
	 INTO result
FROM
	course
	INNER JOIN
		ids
		ON course.Courseno = ids.Courseno
	INNER JOIN
		subject
		ON ids.PaperID = subject.PaperID

尝试以下方法:

Try with this:

SELECT subject.PaperName, subject.Marks  INTO result   
FROM   course INNER JOIN
                      ids ON course.Courseno = ids.Courseno INNER JOIN
                      subject ON ids.PaperID = subject.PaperID
                      ;

语法是SELECT ... INTO ... FROM.

希望对您有帮助

the syntax is SELECT ... INTO...FROM.

Hope this helps

这篇关于这个查询的语法有问题吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！