<?php
$this->db
->select("tabla1.campo, tabla1.otroCampo, tabla2.unCampo")
->from("tabla1")
->join("tabla2", "tabla1.idTabla2 = tabla2.id")
->limit(15, 10)
->get()
->result();