php - outer - where like laravel

MYSQL Unirse a múltiples columnas de la misma mesa

Question

Estoy tratando de obtener el nombre de habilidad para skill1 , skill2 , y skill3 de la tabla2 usando Join.

Funciona bien cuando trato de obtener skill1 solo. Pero, 1066 Error no exclusivo de tabla / alias aparece cuando trato de obtener detalles para la siguiente columna.

Tabla 1 (tabla de usuario)

======================================
ID Name skill skill2 skill3
======================================
1 Ed 1 4 3
--------------------------------------

Tabla 2 (detalles de la habilidad)

=========================
ID Skill Name
=========================
1 php
2 html
3 css
4 mysql
-------------------------

Esto es lo que espero obtener:

[name] => ''Ed''
[skill1] => ''php''
[skill2] => ''mysql''
[skill3] => ''css''

Aquí está mi código, estoy usando laravel:

DB::table(''table1'')
->join(''table2'', function($join)
{
$join->on(''table1.skill1'', ''='', ''table2.id'');
})
->join(''table2'', function($join)
{
$join->on(''table1.skill2'', ''='', ''table2.id'');
})
->join(''table2'', function($join)
{
$join->on(''table1.skill3'', ''='', ''table2.id'');
})
->get();

Answer 1

Mismo resultado que la consulta @erickmcarvalho

SELECT Table1.usrname,
(SELECT Table2.skillname FROM Table2 WHERE Table1.skill1 = Table2.Id) As skill1,
(SELECT Table2.skillname FROM Table2 WHERE Table1.skill2 = Table2.Id) As skill2,
(SELECT Table2.skillname FROM Table2 WHERE Table1.skill3 = Table2.Id) As skill3
FROM Table1

Aún causa 4 consultas, sería mejor reestructurar tablas

Answer 2

Prueba esta consulta:

SELECT U.Name AS Name, S1.Skill Name AS Skill1, S2.Skill Name AS Skill2, S3.Skill Name AS Skill3
FROM table1 U
JOIN table2 S1 ON (S1.Id = U.skill1)
JOIN table2 S2 ON (S2.Id = U.skill2)
JOIN table2 S3 ON (S3.Id = U.skill3)