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
rdim...@evergreeninfo.net


-----Original Message-----
From: Dr. Hawkins [mailto:doch...@gmail.com] 
Sent: Thursday, November 02, 2017 6:49 PM
To: rdim...@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 <rdim...@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


_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Reply via email to