Sql server sbquery error

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 report

select * 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!

September 3rd, 2015 3:36am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics