SubQuery |
How do this:
$query = $this->db->table('catalog as C')->select(*) ->select('(SELECT `title` FROM `help_catalogs` WHERE `id` = c.parent) AS SubCatalogTitle')
This is how you can handle subqueries: https://www.codeigniter.com/user_guide/d...subqueries
(01-10-2023, 11:50 AM)michalsn Wrote: This is how you can handle subqueries: https://www.codeigniter.com/user_guide/d...subqueries I have variable in subquery which in main query |
Welcome Guest, Not a member yet? Register Sign In |