David Legault wrote:
Thanks for the reply, but I think you misinterpreted what I'm looking
for here.
For the first query I want to be able to get a row record of (in one
query possibly)
team_name for first team (team_id1)
team_name for second team (team_id2)
and each of these team points
Thanks for the reply, but I think you misinterpreted what I'm looking
for here.
For the first query I want to be able to get a row record of (in one
query possibly)
team_name for first team (team_id1)
team_name for second team (team_id2)
and each of these team points
for a list of N games
Hello,
I'm a regular user of MySQL but lately on a personal project I've run
into some very complexe query management and am a little bit confused on
how to get it working. This is a hockey league stats website application.
I have 4 tables with the following columns:
teams - team_id |
Hi,
for the first query,
select concat(team_id,' (',sum(points),')') from games,points
where games.game_id=points.game_id
and games.team_id1=points.team_id
group by team_id
can solve the problem.
For the second, join players and points.
Mathias
Selon David Legault [EMAIL PROTECTED]:
Hello,