How can I filter a Query so that "Customers" with more than one phone does not appear, which in this case would be Carlos as follows the image below. I'm breaking my head and I can not find anywhere on the net this command.
From now thank you!
Query concerned:
SELECT C.IDCLIENTE
, C.NOME
, C.SEXO
, E.BAIRRO
, T.TIPO
, T.NUMERO
FROM CLIENTE C
INNER JOIN ENDERECO E ON C.IDCLIENTE = E.ID_CLIENTE
INNER JOIN TELEFONE T ON C.IDCLIENTE = T.ID_CLIENTE