查询语句

SELECT TMP2.姓名, TMP2.工号, TMP2.日期
FROM 表1 RIGHT JOIN (SELECT 表2.姓名, 表2.工号, TMP.日期
FROM 表2, [SELECT DISTINCT  日期 FROM 表1]. AS TMP) AS TMP2 ON (表1.日期 = TMP2.日期) AND (表1.姓名 = TMP2.姓名)
WHERE (((表1.姓名) Is Null) AND ((表1.日期) Is Null));