Welcome Guest, Not a member yet? Register   Sign In
SubQuery
#1

How do this:

$query = $this->db->table('catalog as C')->select(*)
->select('(SELECT `title` FROM `help_catalogs` WHERE `id` = c.parent) AS SubCatalogTitle')
Reply


Messages In This Thread
SubQuery - by motoroller - 01-10-2023, 08:26 AM
RE: SubQuery - by michalsn - 01-10-2023, 11:50 AM
RE: SubQuery - by motoroller - 01-10-2023, 01:35 PM



Theme © iAndrew 2016 - Forum software by © MyBB