Select Distinct

[smk23]

In this statement:

"SELECT DISTINCT Address1 FROM PostalAddress"

I would also like to see a couple other fields like AddressID and City, but
want only the Address1 to be distinct. How would I write this?

TIA

 

[Ken Snell [MVP]]

Try this:

SELECT Address1, First(AddressID) AS AddID, First(City) As Cty
FROM PostalAddress
GROUP BY Address1;

 

[smk23]

That does it! thanks
--
sam

Try this:

SELECT Address1, First(AddressID) AS AddID, First(City) As Cty
FROM PostalAddress
GROUP BY Address1;