I am having two tables. APP\_REVIEWREPLAY , APP\_USERREVIEW . i am using sub query from different table by where condition , in that the sub query is returning double values , so i am getting error. My error is

```
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

select * from APP_REVIEWREPLAY where RID=(select RID from APP_USERREVIEW where HALLID=7095) 

```