1
Answer

insert from select query in sql error

Mani Kandan

Mani Kandan

8y
299
1
Hello sir,
 
How to solve this error?
 
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 
 
 
insert into Channel_UniverseValues(Universe,Year,Channel_DetailsId) values ((select Universe from Tble_One where Universe is not null),'2015',

(select id from Channel_Details inner join Tble_One on Channel_Details.ChannelName = Tble_One.Channels))
Answers (1)