Problem. Please help :)

Question

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!
:-)

Answer 1

first create an extra field as player ID then you can apply inner joint and create a new table and easily calculate the wins of player

Answer 2

use union, first query calculate when 'Rob' win a game as a player_home and the second query as a player_away