results of SPLIT when keys not unique

Dr. Hawkins dochawk at
Thu Nov 2 18:48:58 EDT 2017

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

(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