2
As I can filter a Query so that the "Customers" do not appear with more than one phone, which in case would be Carlos as follows the image below. I’m breaking my head and I can’t find anywhere on the net this command.
Thank you in advance!
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
Ah yes, thank you very much.
– Paulo Sergio G.M. Filho