TRANSFORM first(成绩)
SELECT a.姓名ID, 姓名, avg(成绩) AS 平均成绩
FROM [SELECT *
FROM (b105x3 AS a INNER JOIN b105x2 AS b ON [a].科目ID=b.科目ID) INNER JOIN b105x1 AS c ON [a].姓名ID=c.姓名ID]. AS [%$##@_Alias]
GROUP BY a.姓名ID, 姓名
PIVOT 科目;
B105X1、B105X2、B105X3为相应的3表,你自己修改一下。