Query from multiple tables

[eluser]dUspan[/eluser]
$query = "SELECT * FROM tbl1 LEFT JOIN tbl2 ".
"ON tbl1.ID = tbl2.ID WHERE tbl1.id = 1"

$this->db->query($query);

try this.im not sure.but i hope it helps.