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.