I wasn't trying to be a smartalec, sorry if it came off that way. I was trying to emphasize that the name you use for the table alias is completely irrelevant if there are no references to it, but SQL Server still insists that you put something there. Feel free to change it to ScottIsAJerk.