G
Guest
I have the following sql query. I want the STREET to be DISTINCT and only get
the first occurance but keep the other data. Can anyone help me with syntax
on modifying what I have? Thanks in advance!
SELECT [High Propensity Voter Non Absentee].NAME, [High Propensity Voter Non
Absentee].STREET, [High Propensity Voter Non Absentee].CITY, [High Propensity
Voter Non Absentee].STATE, [High Propensity Voter Non Absentee].ZIP, [High
Propensity Voter Non Absentee].VH03082005, [High Propensity Voter Non
Absentee].VH11022004
FROM [High Propensity Voter Non Absentee]
WHERE ((([High Propensity Voter Non Absentee].CITY)="EL DORADO HILLS") AND
(([High Propensity Voter Non Absentee].VH03082005)="V" Or ([High Propensity
Voter Non Absentee].VH03082005)="A") AND (([High Propensity Voter Non
Absentee].VH11022004)="V" Or ([High Propensity Voter Non
Absentee].VH11022004)="A"))
ORDER BY [High Propensity Voter Non Absentee].STREET;
the first occurance but keep the other data. Can anyone help me with syntax
on modifying what I have? Thanks in advance!
SELECT [High Propensity Voter Non Absentee].NAME, [High Propensity Voter Non
Absentee].STREET, [High Propensity Voter Non Absentee].CITY, [High Propensity
Voter Non Absentee].STATE, [High Propensity Voter Non Absentee].ZIP, [High
Propensity Voter Non Absentee].VH03082005, [High Propensity Voter Non
Absentee].VH11022004
FROM [High Propensity Voter Non Absentee]
WHERE ((([High Propensity Voter Non Absentee].CITY)="EL DORADO HILLS") AND
(([High Propensity Voter Non Absentee].VH03082005)="V" Or ([High Propensity
Voter Non Absentee].VH03082005)="A") AND (([High Propensity Voter Non
Absentee].VH11022004)="V" Or ([High Propensity Voter Non
Absentee].VH11022004)="A"))
ORDER BY [High Propensity Voter Non Absentee].STREET;