You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Single row sub query returns more than one Row error

1 reply [Last post]
Guest's picture

Hi All,

I am getting error like " Single row sub query return more than one row" while insert into another record. The query is like....

Insert into abc
select a,
from xyz;

the select statement is working fine. But while insertion, I am facing this error. I am getting this is DEV environment. But it is working fine with other two environments. Please let me know what is the issue... Thanks in advance

Guest's picture
Guest (not verified)
Re: Single row sub query returns more than one Row error

Dear Friend,

Ur sql select statement picks more than one value. Please check for the keyfileds/ constraints and filters(if any)

Post new comment

The question below is to prevent automated spam submissions.
6 + 9 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.