The select statement and the delete statement are two different, separate statements. The delete statement won't have any knowledge of any aliases in the select statement. I am guessing you...