0 - 3 of 3 tags for alias

What is the benefits of using Table aliasing? Can it improve performance?

I'm trying to run this recursive query but it's giving me an error:

Hi, I am new to SQL and to Teradata so I am sorry if this is a stupid question. I studied real-time programming in school using C. Recently I saw a SQL statement in a BTEQ that didn't sit right with me. Unfortunately I don't have access to Teradata at work. I will have to wait until I get home to play with it but I can't find any fault in my logic. So here goes.