联合查询 相同的列名 laravel join same column name

        ->where('belongsTo', $id)
        ->join('users', 'conversation_messages.sender', '=', 'users.id')
        ->join('user_avatars', 'conversation_messages.sender', '=', 'user_avatars.id')
        ->select('users.name', 'conversation_messages.*', 'user_avatars.name', 'user_avatars.filetype')
        ->get();
    return $conversation;

正确答案

    $query = DB::table('packages')
        ->join('assigned_packages', function($join) use($id)
        {
            $join->on('packages.id', '=', 'assigned_packages.registered_package_id')
                ->where('assigned_packages.customer_id', '=', $id);
        })
        ->join('registered_packages', function($join)
        {
            $join->on('packages.id', '=', 'registered_packages.id')
                ->on('registered_packages.id', '=', 'assigned_packages.registered_package_id');
        });

->join(...)
->join(...)
->select(DB::raw('packages.name as name1, assigned_packages.name as name2'))
->get();

$sql = "select a.name as name1, b.name as name2"; $sql .= " from a left join b on a.id=b.id1 and b.id2=&id"; $result = DB::select($sql);
来自 http://stackoverflow.com/questions/25859626/laravel-4-join-same-column-name

DB::table('cases') ->join('contacts', 'cases.id', '=', 'contacts.id') ->select('cases.name', 'contacts.name') ->get();
正确答案

DB::table('cases') ->join('contacts', 'cases.id', '=', 'contacts.id') ->selectRaw('cases.name as cases_name, contacts.name as contacts_name') ->get();

来自 http://stackoverflow.com/questions/24791984/laravel-query-with-joins-same-name-in-multiple-tables