Mark
You can do this: Select street_name From Streets_File Group By street_name .
This will give you all differents street names only one time.
Alejandro
----- Original Message -----
From: Mark Clute <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 16, 2001 1:22 PM
Subject: MI-L SQL Question
> I have a street file that I want to extract a list of the street names but
I only want the first occurrence of any given street. Can I do a simple SQL
to pick the first observance of a street name and disregard any
reoccurrences, if any?
>
>
>
> _______________________________________________________________________
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, send e-mail to [EMAIL PROTECTED] and
> put "unsubscribe MapInfo-L" in the message body.
>
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
