Database
Eloquent
Views
DB::table('users') ->join('contacts', function($join) { $join->on('users.id', '=', 'contacts.user_id')->orOn(...); }) ->join('newRel', function($join) { $join->on('users.id', '=', 'contacts.user_id')->orOn(...); }) ->get();
Let's say both users and contacts has the same column name ID how do I give it a unique name eg usersID , contactsID instead of both being ID only.
Last updated
3 years ago.
->select('users.id as users_id, contacts.id as contacts_id, users.name as users_name')
and just keep adding the columns with table prefix
Last updated
3 years ago.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast