select c.CustomerID, c.FirstName, c.LastName, o.OrderID
from Customers as c join Orders as o on c.CustomerID = o.CustomerID
where o.OrderID = 13