SELECT
    *
FROM
    (
    SELECT
        `ОТ`.`КодР`,
        `ОТ`.`No`
    FROM
        `ОТ`
    WHERE
        `ОТ`.`No` NOT IN(
        SELECT DISTINCT
            `ПР`.`Noo`
        FROM
            `Р_Н`
        JOIN
            `ОТ`
        ON
            `ОТ`.`КодР` = `Р_Н`.`Код`
        RIGHT JOIN
            `ПР`
        ON
            `ОТ`.`No` = `ПР`.`Noo`
        WHERE
            `Р_Н`.`Код` IS NULL
    )
) NotNullProjs
RIGHT JOIN
    (
    SELECT
        `Р_Н`.`Код`,
        `Р_Н`.`Np`,
        `ОТ`.`No`
    FROM
        `ОТ`
    JOIN
        `Р_Н`
    ON
        `Р_Н`.`Код` = `ОТ`.`КодР`
) BossCodes
ON
    BossCodes.`Код` = NotNullProjs.`КодР`
WHERE
    BossCodes.`No` != NotNullProjs.`No`