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


Simple questions regarding the syntax for db->join :

Should I put a "AS" in

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

Both seem to work.

Thank you for your help

You can use the second one,
db->join('table tbl','conditions')
you only use 'as' on column names in select

Thank you

Theme © iAndrew 2016 - Forum software by © MyBB