[RESOLVED] Aggregate Query?

sois

How do I combine (join?) these two queries to get the aggregate win total for the player from both tables? For example, I want to know how many games I have won as singles and as doubles. Thanks.

select PLAYER, sum(WIN)as W from singles PLAYER

and 

select PLAYER, sum(WIN)as W from doubles PLAYER

ednark

Look up UNION. As long as the columns match up (which they do) you should be good

select PLAYER, sum(WIN) as W from singles PLAYER
UNION
select PLAYER, sum(WIN) as W from doubles PLAYER

sois

Doesn't group by the player 🙁


Rank	Name	Wins
1.	Aaron	4
2.	Eric	9
3.	Travis	2
4.	Aaron	16
5.	Eric	21
6.	Travis	8

Roger_Ramjet

select player, sum(win) from
(select player, win from singles
union
select player, win from doubles) as t
group by player

sois

Roger Ramjet wrote:

select player, sum(win) from
(select player, win from singles
union
select player, win from doubles) as t
group by player

Thanks this is great, I didn't know about sub queries before! Excellent!