Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
insert from select query in sql error
Mani Kandan
May 30 2016 4:56 AM
284
Reply
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))
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Joining two tables
What the problem in oda.Fill(ds);?