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