I'm trying to select sums from a giant table and post it into different columns.
SELECT
[Award Year],
SUM([Project Value]) AS LNG
FROM
[Job Query]
WHERE
[Project Type]="LNG"
GROUP BY [Award Year]
This gives one column but I have other ones like MetalsMining, OG, Others etc... How do I put all these columns together into one query so that my resulting table lists [Award Year], LNG, MetalsMining, OG, Others etc...?
...
Go to the complete details ...