Active Record : Join syntax precision

[eluser]Gilles_T[/eluser]
Hi,

Simple questions regarding the syntax for db->join :

Should I put a "AS" in

Code:

db->join('mytable_1 AS t1',...) or db->join('mytable_1 t1',...)

Both seem to work.


Thank you for your help

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

Code:

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

you only use 'as' on column names in select

[eluser]Gilles_T[/eluser]
Thank you