Crosstab from Access to sql

Hi,

Is anyone able to convert the following MSAccess crosstab query into sql for me please. My sql is fairly basic, hence using the access builder for some things, but I can't paste this back into heidi.

TRANSFORM Sum(game_actions_home_goals.status_time) AS SumOfstatus_time
SELECT validgames.game_id
FROM validgames LEFT JOIN game_actions_home_goals ON validgames.game_id=game_actions_home_goals.game_id
GROUP BY validgames.game_id
PIVOT game_actions_home_goals.status_time;



Many thanks if you can.