Adding Records at Start

[Mark Maslowski]

> What it looks like you need is to have all level_1 records with the same
> name to have the same ID.
> 
> Level_1 Level_2        ID
> Horse   Arab            2
> Horse   Thoroughbred    2
> Fish    Carp            1
> Fish    Goldfish        1
> Fish    Shark           1
> 
> Using SELECT DISTINCT Level_1 Order by ID
> 
> Will sort this out into two records with Fish first followed by Horse.
> 
> If you then want to sort Level_2 as well you would probably need to have a
> secondary sort ID.

My, aren't we clever! ;)  Yes, that seems to have worked.

Thanks a million!

- Mark

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

Mark D. Maslowski
Partner/Designer/Programmer

MAJICo - The Mark and June Interactive Company
Serving Northern California - from Napa to Monterey!
www.majico.com

831-336-3343 voice       831-336-3353 fax

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*