+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Installation & Setup (https://forum.codeigniter.com/forumdisplay.php?fid=9)
+--- Thread: How to implement subquery (/showthread.php?tid=83460)
How to implement subquery - rashh - 09-27-2022
How to exercise the below query in query builder?
SELECT * FROM `user` WHERE uid=1311 and Qid NOT IN (SELECT Qid FROM subm WHERE uid='1311' and Sid='5721');
I tried this,
$this->user->where('uid', '1311')->whereNotIn('Qid', $this->subm->select('Qid')->where('uid', '1311')->where('Sid','5721')->find())->find();
But it throws this,
ErrorException
Array to string conversion