results of SPLIT when keys not unique

[Dr. Hawkins]

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