[SOLVED] Active Record - Table Alias

[eluser]fszostak[/eluser]
I know about case-sensitive problems, but table names and field names are okay.

I solved the problem, the alias must be in UPPERCASE.

Take a look:

Code:

$this->db->select("T1.id, T1.title, T2.name");
$this->db->from("table1 T1");
$this->db->join("table2 T2", "T1.user_id = T2.id");
$this->db->where("T1.parent_id", $parent_id);
$query = $this->db->get();
return $query->result();

Thanks!