1
I have the following SELECT
SELECT t.nome, count(t.id)
FROM Partidas p
LEFT JOIN Times t ON p.codTimeCasa = t.id
OR p.codTimeVisitante = t.id
GROUP BY t.nome
I would like him to return the teams that have no link with the table partidas, however it only returns those who have, someone would know the solution of this problem?
1
I believe that using a sub-base with NOT EXISTS, you can solve this.
SELECT t.nome, count(t.id)
FROM Partidas p
WHERE NOT EXISTS (SELECT NULL From Time t WHERE t.id = p.codTimeCasa OR t.id = p.codTimeVisitante)
GROUP BY t.nome
More details on this link: https://technet.microsoft.com/pt-br/library/ms184297(v=sql.105). aspx
Thank you very much for the answer, but what I need is the teams that have matches and the teams that do not, this your select returned the following error :ERROR: Missing FROM-clause entry for table "t" LINE 1: SELECT Count(t. id).
Browser other questions tagged sql
You are not signed in. Login or sign up in order to post.
Flip the sides (or the Join type) to start. SELECT FROM times LEFT JOIN matches. after all you want the teams. About returning the unlisted, that’s what I answered here: How to return only records without matching in a JOIN?
– Bacco
@Bacco was that very thank you
– Ismael Hartmann