Active Record : Join syntax precision

[eluser]CodeIgniteMe[/eluser]
You can use the second one,

Code:

db->join('table tbl','conditions')

you only use 'as' on column names in select