Forum Outer Join Clousure

cheycron

posted 10 years ago

Database

Last updated 2 years ago.

cheycron

replied 10 years ago

Solution

Solved:

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

Last updated 2 years ago.

cdiazr

replied 8 years ago

Why you put 'null' twice at last line instead of 'full outer'?

arleneanthea

replied 8 years ago

Preprocessing applies transitive closure to join columns for normal equijoins if join transitive closure is enabled at the server or session.http://www.bestchristmasmessages.com/category/christmas-text-messages/