I need to do a select in four tables but I'm having a headache with this, follow the image of how they're related:
It would be something like:
SELECT integrantes.id_integrante,
integrantes_documento.nome_integrante,
integrantes_endereco.cep_integrante,
votos_uniforme.voto_uniforme1,
votos_uniforme.voto_uniforme2,
votos_uniforme.voto_uniforme3
FROM integrante
I'm just missing the JOIN'S, can anyone help me?