Laravel 4: query builder retrieves join table data

Question

Laravel 4: query builder retrieves join table data

In Laravel, we could join two tables with this:

DB::table("users")->join('moreusers', 'users.id', '=', 'moreusers.user_id')->get();

And extract the data using this:

$querydata[$i]->email

If both tables contain the same column name, how can I get it from the first and second table?

Thank.

+3

php mysql laravel-4

user1995781 Feb 21 '14 at 9:31

source share

1 answer

aykut · Accepted Answer · 2014-02-21T09:36:50+0000

Use method select():

DB::table("users")
    ->join('moreusers', 'users.id', '=', 'moreusers.user_id')
    ->select('users.email as user_email', 'moreusers.email as other_email')
    ->get();

Laravel 4: query builder retrieves join table data

More articles: