• Here is a script demonstrating a delete using an alias as well as using the alias X

    Use Tempdb;

    GO

    CREATE TABLE demodelete (somenum INT);

    INSERT INTO demodelete (somenum)

    VALUES (1),(2),(3),(4);

    SELECT * FROM demodelete;

    DELETE X

    FROM demodelete x

    WHERE x.somenum = 1;

    SELECT *

    FROM demodelete;

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events