I've been digging through search results and think this should work... but it doesn't.
SELECT A.ID, A.First_Name, A.Last_Name, A.Address_1, A.Address_2, A.Address_3, A.City, A.State, A.Zip, A.Phone, A.Terr_Name, A.[PRS Mkt Vol Decile], A.Special, A.HomeCareRepID, A.ManagerID
FROM...