Multiple SELECT statements in INSERT INTO query in SQL

Question

 INSERT INTO TextTable(Number, Tokens)  
 SELECT 
 (SELECT  ID FROM  Tureme WHERE leksem IN  
 (SELECT  Tokens FROM  Text)),
 (SELECT  Tokens FROM Text WHERE Tokens IN 
 (SELECT  leksem FROM Tureme));

TextTable has two columns-> Number,Tokens Tureme has two columns -> ID(Primary Key), leksem and Text has one column -> Tokens

My tables:

TextTable is empty.

What I'm trying to do is inserting the results of these subqueries into TextTable. The subqueries works perfect individually. But, when I run it together, it doesn't insert results of subqueries and it gives an error saying:

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated.

What should i do?

First subquery returns: Second subquery returns:

ID Tokens

4                              apple
6                              melon
9                              pear

I want to populate TextTable with these values.

Please show some example data. Do the sub queries even return the same number of rows? How should the rows from the left hand sub query be correlated with the rows from the right? — Martin Smith
– Martin Smith, Commented Nov 8, 2011 at 11:09

Hogan · Accepted Answer · 2011-11-08 11:27:39Z

1

Based on your new comments this is what you want for the select statement

SELECT ID, Text.Tokens
FROM Tureme
JOIN Text ON Tureme.leksem = Text.Tokens

You need to join the tables in the query -- otherwise the results don't relate to each other.

edited Nov 8, 2011 at 11:27

answered Nov 8, 2011 at 11:12

Hogan

70.7k10 gold badges83 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Martin Smith Over a year ago

What is the point of even submitting this answer? There's probably a 0.01% chance that this is what the OP wants (undeterministic arbitrary top expression). The "Please define your problem better" point can be made in a comment.

Hogan Over a year ago

@MartinSmith - The point is very clear. This answer shows the OP what the compiler wants -- hopfully it will make it clear to him how to make the problem definition better or what the actual solution is. Yes it is like a comment but it is long and would have been hard to read in a comment. It could even be what he wanted to do -- since we both don't know.

LuckySlevin Over a year ago

I needed to Insert without duplicates. Thanks for the effort.

LuckySlevin · Accepted Answer · 2011-11-08 11:34:35Z

1

INSERT INTO TextTable
SELECT DISTINCT ID, Text.Tokens
FROM Tureme
JOIN Text ON Tureme.leksem = Text.Tokens

I guess this is exactly what you want.

answered Nov 8, 2011 at 11:34

LuckySlevin

7453 gold badges16 silver badges23 bronze badges

1 Comment

LuckySlevin Over a year ago

exactly this is what I want. Thanks a lot!

Collectives™ on Stack Overflow

Multiple SELECT statements in INSERT INTO query in SQL

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related