jordennabbe

howto sum columns in one table with different conditions

2 posts in this topic

Hello,

 

Can someone help please.

I have a table with a

 

player_home,

player_away,

team_home,

team_away,

score_home,

score_away

 

player_home always has team_home and score_home.

player_away always has team_away and score_away

 

Problem is on one row the player 'Rob' can be player_home and the next row he is player_away.

 

What I wanna get out of this table is..

How many times did 'Rob' win a game?

How can I query this?

I appreciate the help!

:-)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now