引用地址https://himynameistim.wordpress.com/2014/04/07/sql-server-selecting-top-1-in-a-left-join/
SELECT c.*, la.*
FROM Customer c
OUTER APPLY
(SELECT TOP 1 *
FROM Address a
WHERE a.CustomerID = c.CustomerID
ORDER BY a.DateAdded DESC
) AS la