SELECT A.*, C.*, D.*, E.*, F.*, F.Precinct As aPrecinct, F.grp As aGroup FROM VoterLookupDetail AS A LEFT JOIN EthnicityDesc AS C ON A.EthnicityCode = C.Code LEFT JOIN DIST_CityDesc As D ON A.CityCode = D.Code LEFT JOIN DIST_PartyDesc As E ON A.PartyCode = E.Code LEFT JOIN DIST_Precincts As F ON A.PrecinctID = F.precinct_id  Where HouseNo = '80' And  Replace(Replace(Replace(LastName, ' ', ''), '''', ''), '-', '') Like 'SMITH%' And VoteType <> 'Z' Order By LastName, FirstName