Full Outer Join in Laravel

Question

Full Outer Join in Laravel

Navigation

#1 by (0 votes)

0

my query is like doing a FULL OUTER JOIN in Laravel, I have version 5.1

Example:

Thank you very much.

mysql sql php join laravel

asked by David777 31.01.2017 в 04:38

source

1 answer

I have a problem when sending purchase data by mail, I use an array to add it to the shopping cart search by type does not work

score 0 · Answer 1

Good morning I found this, maybe it will help you:

->join('Entradas',function ($join) {
$join->on('Entradas.paci_CodigoNumerico', '=', 'Turnos.paci_CodigoNumerico')
->on('Entradas.medi_Codigo', '=', 'Turnos.medi_Codigo')
->on('Entradas.espe_Codigo', '=', 'Turnos.espe_Codigo')
->on($this->raw('convert(varchar, Entradas.entr_Fecha, 112)'), '=', $this->raw('convert(varchar, Turnos.turn_FechaTurno, 112)'))
->on('Entradas.ubic_Codigo', '=', 'HorarioMedico.ubic_Codigo'), null, null, 'full outer';

I give you the link so you can see it better. link