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

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -