[SOLVED] How to use MySQL alias join with CI's Active Record

[eluser]tkaw220[/eluser]
Hi noctrum,

Is my code below correct?

Code:

$this->db->select('inventory_logs.log_no as l, l.transaction, l.bookseller_id, l.type, l.purchase_order, l.job_sheet, l.invoice, l.delivery_order, l.note, l.user, l.log_date, booksellers.name as b, b.id')
->join('booksellers', 'l.bookseller_id = b.id', 'left')
->where('inventory_logs.log_no', $log_no);

Thank you.