Jump to content

romntkac

Members
  • Content count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About romntkac

  • Rank
    Newbie
  1. romntkac

    Complex query - help needed :)

    Hello everyone, I need your advise to get the following output table: Team Scored Received GoalDiff Argentina 3 1 2 Germany 4 4 0 Nigeria 3 4 -1 Japan 1 2 -1 From this input table: HomeTeam AwayTeam HomeScore AwayScore Argentina Nigeria 2 0 Germany Japan 1 1 Japan Argentina 0 1 Germany Nigeria 2 3 Nigeria Japan 0 0 Germany Argentina 1 0 Any suggestions? Thanks for the help!
×