select Person.LastName,Person.FirstName,Orders.OrderNo from Persons INNER JOIN Orders ON Person.Id_P=Orders.Id_P ORDER BY Person.LastName
inner join
原文：http://www.cnblogs.com/zzzzw/p/4914282.html
