Hi,
wie kann ich aus diesem impliziten Join einen expliziten Join machen?
Bin am verzweifeln![Stirnrunzeln](https://entwickler-forum.de/core/images/smilies/frown.png)
[highlight=sql]
SELECT
b.name,
b.firstname,
c.season,
SUM(d.goals) AS Goals
FROM players a, persons b, matches c, playerMatches d
WHERE a.personId = b.personId
AND a.playerId = d.playerId
AND c.matchId = d.matchId
AND Goals IS NOT NULL
GROUP BY b.name, b.firstname, c.season
ORDER BY c.season, Goals DESC, b.name[/highlight]
mfg 0per8or
wie kann ich aus diesem impliziten Join einen expliziten Join machen?
Bin am verzweifeln
![Stirnrunzeln](https://entwickler-forum.de/core/images/smilies/frown.png)
[highlight=sql]
SELECT
b.name,
b.firstname,
c.season,
SUM(d.goals) AS Goals
FROM players a, persons b, matches c, playerMatches d
WHERE a.personId = b.personId
AND a.playerId = d.playerId
AND c.matchId = d.matchId
AND Goals IS NOT NULL
GROUP BY b.name, b.firstname, c.season
ORDER BY c.season, Goals DESC, b.name[/highlight]
mfg 0per8or
Comment