Welcome Guest, Not a member yet? Register   Sign In
Active Record : Join syntax precision
#1

[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
#2

[eluser]CodeIgniteMe[/eluser]
You can use the second one,
Code:
db->join('table tbl','conditions')
you only use 'as' on column names in select
#3

[eluser]Gilles_T[/eluser]
Thank you




Theme © iAndrew 2016 - Forum software by © MyBB