How to do this JOIN query in Laravel?

Question

I'm trying to do this join in laravel query builder but it is throwing and error. I'm using and Mysql DB. This is my sql:

select c.*, d.* from notas_cabecera c
join notas_detalle d on (c.codigo_nota = d.codigo_nota)
where c.codigo_nota in (select r.codigo_nota from reportes r);

And this is my laravel query:

$lista_reportes = DB::table('notas_cabecera')
                              ->join('notas_detalle', 'notas_cabecera.codigo_nota', '=', 'notas_detalle.codigo_nota')
                              ->whereIn('notas_cabecera.codigo_nota', function($query)
                              {
                                    $query->select(
                                              DB::table('reportes')->select('reportes.codigo_nota')
                                            );
                              })
                              ->get();

What I'm doing wrong? please help.

For starters, you're not telling us what the error is.

ceejayoz
– ceejayoz

2015-01-31 02:17:55 +00:00
Commented Jan 31, 2015 at 2:17 — ceejayoz
– ceejayoz, Commented Jan 31, 2015 at 2:17

Tim · Accepted Answer · 2015-01-31 02:39:59Z

1

$lista_reportes = DB::table('notas_cabecera')
                              ->join('notas_detalle', 'notas_cabecera.codigo_nota', '=', 'notas_detalle.codigo_nota')
                              ->whereIn('notas_cabecera.codigo_nota', function($query)
                              {
                                    $query
                                        ->select('reportes.codigo_nota')
                                        ->from('reportes');
                              })
                              ->get();

answered Jan 31, 2015 at 2:39

Tim

2851 gold badge2 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

How to do this JOIN query in Laravel?

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