• I guess there is something wrong with this question as it should be like follows:

    SELECT X AS 'Except'

    FROM A

    EXCEPT

    SELECT Y

    FROM B

    but maybe the author took it copy/paste from his 1st question and forgot to change the code.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant