Create subquery in WHERE |
I have subquery like this its working, how i can rewrite with active record?
$builder->where("(SELECT SUM(sum) FROM payments WHERE visit = v.id) > 0"); Like this $SubQuery = $this->db->table('payments ')->select('SUM(sum)')->where('visit = v.id'); $MainQuery = $this->db->table('visits')->where("$SubQuery > 0") |
Messages In This Thread |
Create subquery in WHERE - by motoroller - 01-18-2023, 03:42 AM
RE: Create subquery in WHERE - by Codinglander - 01-18-2023, 04:31 AM
|