[eluser]matt2012[/eluser]
I want to use active record to create a subquery join in the
from call
however this syntax fails because CI escapes the `select` `from` etc.
setting
select to false does not solve the problem as the query is not in the select
call.
Code:
$this->db->from("table1 LEFT JOIN
( select col1, col2
from table2
where id = 13
) as table3
ON table1.col1 = table3.col1");