Level 50
You can use select in order to select from which table you want to pick the columns with the same name:
DB::table('table1')->join('table2','table1.id','=','table2.table1_id')->orderByRaw('position')->select('table1.*')->get()
Feb 19, 2019
1
Level 1
Same Columns in two tables, query builder
Hi! I've a sql Query DB::table('table1')->join('table2','table1.id','=','table2.table1_id')->orderByRaw('position')->get();
In both tables, table1 and table2 is a column id. After the request I get a collection with one attribute id, the id attribute ist from table2 Why? How can I change this to id from table1? So I need something like table1.id or?
Please or to participate in this conversation.