All arguments within an ALLEXCEPT function must be related to (or contained by) the table which is used as the first argument. ...

All arguments within an ALLEXCEPT function must be related to (or contained by) the table which is used as the first argument. Where a one-to-many relationship exists, the table which is used as the first argument must be on the 'many' side of that relationship.