SQL alias

« Previous Chapter Next Chapter »

With SQL, an alias name can be given to a table or to a column.

SQL alias

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.

SQL alias Syntax for Tables

SELECT column_name(s)
FROM table_name
AS alias_name

SQL alias Syntax for Columns

SELECT column_name AS alias_name
FROM table_name

alias Example

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:

SELECT po.PurchadeNum, p.LastName, p.FirstName
FROM Persons AS p,
Product_Purchases AS po
WHERE p.LastName='Karmen' AND p.FirstName='Kasa'

The same SELECT statement without aliases:

SELECT Product_Purchases.PurchadeNum, Persons.LastName, Persons.FirstName
FROM Persons,
WHERE Persons.LastName='Karmen' AND Persons.FirstName='Kasa'

As you'll see from the two SELECT statements above; aliases can make queries easier to both write and to read.

« Previous Chapter Next Chapter »

Have Any Suggestion? We Are Waiting To Hear from YOU!

Your Query was successfully sent!