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 [email protected] -----Original Message----- From: Dr. Hawkins [mailto:[email protected]] Sent: Thursday, November 02, 2017 6:49 PM To: [email protected] 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 <[email protected]> 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 [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
