Hi,
I have an update query in the report.Iam using the below query after using upadte statemnts of feature1_id,feature2_idfeature3_id,feature4_idfeature5_id in Phone Table from the reportselect * from phone
where phonenumber in (select phonenumber from #phones)
and (feature1_id <> @correct_ft) and (feature2_id <> @correct_ft)
and (feature3_id <> @correct_ft) and (feature4_id <> @correct_ft)
and (feature5_id <> @correct_ft)
END
ELSE
select * from phone p
inner join #phones _p on p.phonenumber = _p.phonenumber
when I run the report iam getting error.see below error details
Unexpected error: 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.
Please any one solve this error.Thanks!