Найти докторов, которые делали назначения пациентам из тех палат, которые они не посещали

SELECT qp.TabNomer, qp.LastNameDoctor, qp.NumPalat
FROM (SELECT Doctor.TabNomer, Doctor.LastNameDoctor, Palata.NumPalat
      FROM Doctor INNER JOIN Palata ON Doctor.TabNomer = Palata.TabNomer) AS qp
WHERE NumPalat NOT IN  (SELECT NumPalat FROM (SELECT MidTable.TabNomer, Patient.UchNomer, Palata.NumPalat
                          FROM (Patient INNER JOIN MidTable 
                          ON Patient.UchNomer = MidTable.UchNomer) 
                          INNER JOIN (Palata INNER JOIN T3 ON Palata.NumPalat = T3.NumPalat) 
                          ON Patient.UchNomer = T3.UchNomer) AS qb WHERE qb.TabNomer=qp.TabNomer)

SELECT DISTINCT Z.TabNomer, Z.LastNameDoctor
FROM (SELECT MidTable.TabNomer, MidTable.UchNomer, Doctor.LastNameDoctor 
FROM MidTable INNER JOIN Doctor ON MidTable.TabNomer=Doctor.TabNomer) AS Z 
LEFT JOIN  
(SELECT Palata.TabNomer, T3.UchNomer, Palata.NumPalat
FROM Palata INNER JOIN T3 ON Palata.NumPalat = T3.NumPalat)  AS Q 
ON (Z.TabNomer = Q.TabNomer) AND (Z.UchNomer = Q.UchNomer)
WHERE Q.NumPalat IS NULL