With SQL, an alias name can be given to a table or to a column.
You can give a table or a column another name by using an alias. This can be a good thing to do
if you have very long or complex table names or column names.
An alias name could be anything, but usually it is short.
Assume we have a table called "Persons" and another table called "Product_Purchases".
We will give the table aliases of "p" and "po" respectively.
Now we want to list all the Purchases that "Kasa Karmen" is responsible for.
We use the following SELECT statement:
The same SELECT statement without aliases:
As you'll see from the two SELECT statements above; aliases can make queries easier to both write
and to read.
Your Query was successfully sent!