SELECT Difference.Zkzh AS 准考证号码, Difference.Code AS 报名号, Difference.Name AS 姓名, Difference.FieldName AS 列, IIf(IsNull([temp_1].[名称]),[before],[temp_1].[名称]) AS 以前, IIf(IsNull([temp_1_1].[名称]),[now],[temp_1_1].[名称]) AS 现在
FROM (Difference LEFT JOIN temp_1 ON Difference.Before = temp_1.代码) LEFT JOIN temp_1 AS temp_1_1 ON Difference.[Now] = temp_1_1.代码
ORDER BY Difference.Zkzh;