title: Retrieve same column twice with different conditions
body: <p>This question is already answered multiple times but I just can't get it to works. I tied use some answer from <a href="https://stackoverflow.com/questions/16423883/how-to-retrieve-same-column-twice-with-different-conditions-in-same-table">this</a> question but I always "get error more than one row returned by a subquery used as an expression"</p>
  
  <p>I have following sql query:</p>
  
  <pre><code>SELECT DISTINCT p.name, pma.time AS  goal, pma.time AS assist 
  
  FROM player p
  
  INNER JOIN player_match pm
  ON p.player_id = pm.player_id
  
  INNER JOIN matches m
  ON m.match_id = pm.match_id
  
  INNER JOIN team_match tm
  ON tm.team_id = p.team_id 
  
  FULL JOIN player_match_activity pma
  ON pma.player_id = p.player_id
  AND pma.activity_id = '1'
  AND pma.match_id = m.match_id
  
  WHERE m.match_id = '163'
  AND tm.home_away = 'home'
  </code></pre>
  
  <p>The query gives me following result:</p>
  
  <pre><code> name    |    goal    |    assist
  -------------------------------------
  Ronaldo         1            1
  Messi           3            3
  Vardy  
  </code></pre>
  
  <p>The column "assist" show same values like the column "goal". 
  Line pma.activity_id = '1' select just goals. </p>
  
  <p>How can I set that the column "assist" use exact same conditions like the column "goal" BUT instead of  pma.activity_id = '1' I want to change it to '2" ?</p>