inner join

select Person.LastName,Person.FirstName,Orders.OrderNo from Persons INNER JOIN Orders
ON Person.Id_P=Orders.Id_P ORDER BY Person.LastName