Tuesday, April 4, 2017

laravel getting error on using alias in joins 4.1

Getting erroe as ORA-00905: missing keyword Position in laravel 4.1

->leftjoin('table1','table1.portid','=','ordertable.order_id')

->leftjoin('table2 as dep','dep.portid','=','ordertable.departure')

->leftjoin('table2 as arr','arr.portid','=','ordertable.arrival')

On using alias for join 2(table2 as dep) and 3 (table2 as arr) getting error, Can Someone let me know where I have to use as, am I correct with the syntax V4.1



via fernandus

Advertisement