sql中的Alias怎么用

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

不使用别名的 SELECT 语句：

 1   SELECT   Product_Orders.OrderID, Persons.LastName, Persons.FirstName
  2   FROM   Persons, Product_Orders
  3   WHERE  Persons.LastName =  ‘  Adams  ‘   AND  Persons.FirstName =  ‘  John  ‘ 

 

sql中的Alias怎么用

标签：

查看更多关于sql中的Alias怎么用的详细内容...