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