results of SPLIT when keys not unique

[Ralph DiMola]

I waaaayyy over thought this. This is tested:


SELECT animals.animalnumber, animals.animalname
FROM animals
GROUP BY animals.animalname;

Ralph DiMola
IT Director
Evergreen Information Services
rdimola at evergreeninfo.net


-----Original Message-----
From: Dr. Hawkins [mailto:dochawk at gmail.com] 
Sent: Thursday, November 02, 2017 6:49 PM
To: rdimola at evergreeninfo.net
Cc: How to use LiveCode
Subject: Re: results of SPLIT when keys not unique

On Thu, Nov 2, 2017 at 3:45 PM, Ralph DiMola <rdimola at evergreeninfo.net> wrote:
> Whoops, not tested and I saw an error.
>
> Select mytable.animalname,mytable.animalnumber from (select distinct 
> mytable.animalname from mytable as mytable2) left join mytable on 
> mytable.animalname = mytable2animalname
>

You just shot *way* over my SQL :)

does that last line search for any mytable.animalname that occurs in mytable2.animalname?

(and if it's that easy, why in the world isn't DISTINCT ON part of SQLite???

thanks




--
Dr. Richard E. Hawkins, Esq.
(702) 508-8462