Laravel DB Join with asterisk and alias select

Question

I am trying to get following query on Laravel:

SELECT 
  table1.* , 
  table1.colb as aaa
FROM 
  table1 
  LEFT jOIN table2 on table2.cola = table1.colb

This is the Laravel DB Query code :

DB::table('table1')
        ->leftJoin('table2','table2.cola', '=', 'table1.colb')
        ->select('table1.* , table1.colb as aaa')
        ->get();

But it doesn't work and I get SQL Syntax error. This is the SQL which Laravel is making using above code which is wrong :

select `table1`.* as `table1.colb` 
from `table1` 
left join `table2` on `table2`.`cola` = `table1`.`colb`

How can I fix this using laravel way?

Bogdan · Accepted Answer · 2015-05-29 09:17:03Z

1

You need to pass multiple parameters to the select method for each one to get prepared correctly:

DB::table('TABLE1')
        ->leftJoin('TABLE2','TABLE2.COLA', '=', 'TABLE1.COLB')
        ->select('TABLE1.*', 'TABLE1.COLB AS AAA') // <- 2 separate params here
        ->get();

answered May 29, 2015 at 9:17

Bogdan

44.7k12 gold badges130 silver badges130 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel DB Join with asterisk and alias select

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related