distal-attribute
distal-attribute
distal-attribute
distal-attribute

Crosstab from Access to sql

lordrom posted 10 months ago in General
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.

Please login to leave a reply, or register at first.