Posts by koga187 • 1 point
1 post
-
0
votes2
answers1836
viewsA: Duplicate column value, how to avoid?
Guy tries to use LEFT JOIN: SELECT p.nome, d.nome, c.valorAuxilio FROM sca_pessoa p LEFT JOIN sca_dependente d ON p.idPessoa = d.idPessoa LEFT JOIN sispro_contrato c ON p.idPessoa = c.idPessoa WHERE…