Left join? Where? I do not see....
Besides, you're on the right truck. You have to replace
. That's all.
FROM tbl_score AS t
GROUP BY t.empid
Note, that you cannot pivot data on multiple fields... So, it's impossible to get
in one query.
For further details, please see: TRANSFORM Statement (Microsoft Access SQL) [Access 2007 Developer Reference]