Subquery returned more than 1 value This is not permitted ??

Hello,

 

It is permitted to insert multiple values using subqueries, the query which you have written is almost correct. But analyzing the query we can summarize that you are trying to insert firstname and lastname from your source table and other values are to be static as you provided (19, UP school) for age and school columns. 

 

Analyzing subqueries most probably both of them would be returning multiple results i.e. multiple columns but the other columns such as age and school would have a single value or single entry. 

 

If you want to enter a single row in the destination table selecting the values for firstname and lastname from the source table, I would suggest you add some condition to the subqueries that you have written to select the values for both using subqueries.

 

You can add some conditions to the query "SELECT sourcetable.firstname From sourcetable"  so that it returns a single firstname and similar for the lastname query.

 

Your query would run successfully if your query evaluates to something like this:

 

 

Hope this helps!