results of SPLIT when keys not unique

Ralph DiMola rdimola at
Thu Nov 2 20:31:59 EDT 2017

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

-----Original Message-----
From: Dr. Hawkins [mailto:dochawk at] 
Sent: Thursday, November 02, 2017 6:49 PM
To: rdimola at
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> 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???


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

More information about the use-livecode mailing list