SQL

[Ksmith404]

select P.firstName, A.[AddressLine1]
from [Person].[Person] P
right JOIN [Person].[Address] A
ON BusinessEntityID = A.AddressID
WHERE AddressLine1 is not null AND FirstName LIKE "A%"
ORDER BY FirstName