sql - select Details fro where condition sub query getting error -
i having 2 tables. app_reviewreplay , app_userreview . using sub query different table condition , in sub query returning double values , getting error. error is
subquery returned more 1 value. not permitted when subquery follows =, !=, <, <= , >, >= or when subquery used expression. select * app_reviewreplay rid=(select rid app_userreview hallid=7095)
either use join
select r.* app_reviewreplay r join app_userreview u on u.rid = r.rid u.hallid=7095
or in
clause
select * app_reviewreplay rid in (select rid app_userreview hallid=7095)
Comments
Post a Comment