我该如何在MS Access中获得与下面SQL代码相同的结果?它不认识EXCEPT
子句...
SELECT DISTINCT
P.Name,
T.Training
FROM Prof AS P,
Training_done AS TC,
Trainings AS T
WHERE (P.Name Like '*' & NameProf & '*')
AND (P.Primary_Area = T.Cod_Area)
EXCEPT
SELECT DISTINCT
P.Name,
T.Training
FROM Prof AS P,
Training_done AS TC,
Trainings AS T
WHERE (P.Name Like '*' & NameProf & '*')
AND (P.Cod_Prof = TC.Cod_Prof);
事先感谢你!
WHERE NOT EXISTS ({except query})
的方式,但你的方法对于这个特定情况来说更加直接。 - Gord Thompson