ник: Igor_1974
Если вложенных запросов будет много, то такой запрос очень долго обрабатывается.
Решил (подсказали) вот так (сохранен как скл инструкция):
SELECT T1.fldDate, T1.fldPara, T1.id AS id_1, T1.fldTeacher AS fldTeacher_1, T1.fldTeacher2 AS fldTeacher2_1, T1.fldPredmet AS fldPredmet_1, T2.id AS id_2, T2.fldTeacher AS fldTeacher_2, T2.fldTeacher2 AS fldTeacher2_2, T2.fldPredmet AS fldPredmet_2
FROM tblResult AS T1 INNER JOIN tblResult AS T2 ON (T1.id<T2.id) AND ((T1.fldTeacher = T2.fldTeacher) OR (T1.fldTeacher2 = T2.fldTeacher2) OR
(T1.fldTeacher = T2.fldTeacher2) OR (T1.fldTeacher2 = T2.fldTeacher)) AND (T1.fldPara = T2.fldPara) AND (T1.fldDate = T2.fldDate);