Laravel 4-JOIN-相同的列名 [英] Laravel 4 - JOIN - Same column name

问题描述

我目前确实使用此代码从我的数据库中检索所需的数据

I do currently use this code to retrieve the required data from my database

    $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');
        });

它工作正常，但是问题在于此表具有相同名称的列，因此结果中仅最后一个.我该如何解决?通常，我会在查询中使用as选项，但老实说，我不知道如何从上方将其添加到当前的JOIN代码中.

It works fine, however the problem is that this tables have columns with the same name, and therefore only the last one is in the result. How can i fix that? Normally i would use the as option in the query, but i honestly do not know how I can add it to my current JOIN code from above.

推荐答案

$query = DB::table('packages')
->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);

这篇关于Laravel 4-JOIN-相同的列名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！