[NBLUG/talk] OT - SQL query question

[Walter Hansen]

I'd use perl and use the index if one is available. I'd suck the indexes
for the records you want into an array and then cycle through the array
coping the records to the new table. There might be a more direct SQL
method though. If you want or need I could probably write you up some
sample code in ten minutes or so. I've never worked directly with dBase
though, but I assume perl can connect to it.

> This is slightly off topic.  I have an old dBase database with 12000
> records.
> There are some records with the same address field.  I need to strip out
> the
> DISTINCT address records into a separate database.
>
> SELECT DISTINCT ADDR1 FROM MYDB gets me the unique addresses but I need
> the
> other fields as well.
>
> What would be the best way to do this?
>
> --
> Mark Street, RHCE
> http://www.oswizards.com
> --
> Key fingerprint = 3949 39E4 6317 7C3C 023E  2B1F 6FB3 06E7 D109 56C0
> GPG key http://www.oswizards.com/pubkey.asc
>
> _______________________________________________
> talk mailing list
> talk at nblug.org
> http://nblug.org/cgi-bin/mailman/listinfo/talk
>
>