Duplicate column value, how to avoid? [duplicate]

Question

Duplicate column value, how to avoid? [duplicate]

Navigation

#1 by (3 votes)
#2 by (0 votes)

2

How do I do exactly so that this Valuation value column does not have its values duplicated, ie instead of four result lines there would be only two.

SELECT p.nome,
       d.nome,
       c.valorAuxilio
FROM sca_pessoa p

INNER JOIN sca_dependente d ON p.idPessoa = d.idPessoa
INNER JOIN sispro_contrato c ON p.idPessoa = c.idPessoa

WHERE p.nome LIKE '%ADEMAR MAGA%'
AND c.idSituacaoContrato = 3 ORDER BY c.valorAuxilio;

mysql sql

asked by anonymous 08.04.2014 / 20:27

2 answers

Is it possible to deny access to the directory and allow access to the .htaccess file? how? Using CallBack in Delphi

score 3 · Answer 1

You would have to group on top of the valorAuxilio field and use aggregate functions on top of the other columns.

SELECT GROUP_CONCAT(p.nome SEPARATOR ';'),
       GROUP_CONCAT(d.nome SEPARATOR ';'),
       c.valorAuxilio
FROM sca_pessoa p

INNER JOIN sca_dependente d ON p.idPessoa = d.idPessoa
INNER JOIN sispro_contrato c ON p.idPessoa = c.idPessoa

WHERE p.nome LIKE '%ADEMAR MAGA%'
AND c.idSituacaoContrato = 3 ORDER BY c.valorAuxilio;

GROUP BY c.valorAuxilio;

Reference:

GROUP BY (Aggregate) Functions

score 0 · Answer 2

Dude 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 p.nome LIKE '%ADEMAR MAGA%'
AND c.idSituacaoContrato = 3 ORDER BY c.valorAuxilio;

Put the description of the tables there so we can take a look.