SQL简单入门教程之Alias（别名）

#select Alias（别名）的用法
select column_names(s)
FROM table_name
AS alias_name  #表的语法
select column_name AS alias_name 
FROM table_name  #列的语法

Alias 实例: 使用表名称别名

SELECT po.OrderID, p.LastName, p.FirstName
FROM Persons AS p, Product_Orders AS po
WHERE p.LastName=‘Adams’ AND p.FirstName=‘John’

Alias 实例: 使用一个列名别名

SELECT LastName AS Family, FirstName AS Name
FROM Persons