Mysql, selecting 4 related tables

Question

I am trying to make a select on 4 different tables. They are all related. It all starts with the Resident.

SELECT morador.*
      ,unidades.*
      ,grupo.*
      ,condominios.*

  FROM morador
  LEFT JOIN unidades
    ON id_morador = morador.id_unidades,
  LEFT JOIN grupo
    ON id_grupo = morador.id_grupo,
  LEFT JOIN condominios
    ON id_condominios = morador.id_condominio

 WHERE morador.id_morador = '1';

Online test: http://sqlfiddle.com/#! 9/537518/5

Answer 1

I think there are some syntax errors, try this.

SELECT 
    morador.*, unidades.*, grupo.*, condominios.*

FROM morador

LEFT JOIN unidades      ON ID_Morador       = morador.id_unidades
LEFT JOIN grupo         ON ID_Grupo         = morador.id_grupo
LEFT JOIN condominios   ON ID_Condominios   = morador.id_condominio

WHERE
    morador.ID_Morador = '1';

Answer 2

I changed SQL, at first I didn’t see the flaw in jois, you’re trying to make left join of everything with the table morador. I think the broker would be the SQL below, change the alias name to what will best suit you.

    SELECT 
    m.*, a.*, b.*, c.*

FROM morador m

LEFT JOIN unidades      a   ON m.id_unidade       = a.id_unidades
LEFT JOIN grupo         b   ON a.ID_Grupo         = b.id_grupo
LEFT JOIN condominios   c   ON b.id_condominio   = c.ID_Condominios

WHERE
    m.ID_Morador = '1';

I ran a test on your Fiddle with this SQL and it ran.

To use the alias in the columns you cannot use the * you will have to list all columns, which is also the most suitable.

SELECT 
    a.nome as uniNome, b.nome as grupNome

The fiddle isn’t working that way, but that’s the way to do it, look at that link where there is an equal answer to your comment doubt.