Structured Query Language (SQL) Tutorials

Aliasing

Knowing how to alias saves you typing

SELECT P.FName, P.LName, T.CatName
FROM People P
RIGHT OUTER JOIN TypePeople T
ON P.Category=T.ID

The tables may look like the following:

People
FName	LName	Category
John	Smith	1
Al	Jones	2

TypePeople
ID	CatName
1	Employee
2	Customer
3	Supplier

The Resulting Table will look like this:

RESULT
FName	LName	CatName
John	Smith	Employee
Al	Jones	Customer
NULL	NULL	Supplier

Another way of aliasing can be seen in the COUNT example

Come learn HTML or Classic ASP in Honolulu, Hawaii!