① 表的SQL Alias 語法
代碼如下 復制代碼SELECT column_name(s) FROM table_name AS alias_name
例子:
代碼如下 復制代碼SELECT po.OrderID, p.LastName, p.FirstNameFROM Persons AS p, Product_Orders AS poWHERE p.LastName='Adams' AND p.FirstName='John'
② 列的SQL Alias 語法
代碼如下 復制代碼SELECT column_name AS alias_name FROM table_name
例子:
代碼如下 復制代碼SELECT LastName AS Family, FirstName AS Name FROM Persons