Hello all,

I have just come across this; renaming columns. Here is some SQL:

SELECT teamname As Team FROM Team WHERE goaldifference >15

Isn' the above the same as:

SELECT teamname FROM Team WHERE goaldifference > 15

What is the purpose of As

Thanks for any help

That's a column alias, so if you put this through MySQL command line you will see the COLUMN for teamname is called "Team" and NOT "teamname" any longer.
If you want a table alias then use the same (after the table name).

Thanks for your help!

I can use SQL practically, but i am clearly missing a lot of theory!