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
Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net -----Original Message----- From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of Dr. Hawkins via use-livecode Sent: Thursday, November 02, 2017 6:24 PM To: How to use LiveCode Cc: Dr. Hawkins Subject: results of SPLIT when keys not unique If I use split such that keys are not unique, will that have the effect of filtering out duplicates? For example, if I have dog 3 dog 5 cat 8 and SPLIT it, will I end up with 5 in entry dog? More specifically, is this a defined behavior, or "just how it currently works" I'm trying to find a quick & clean way around SQLite's lack of "DISTINCT ON"--I need to keep those numbered keys attached to work with, and DISTINCT alone won't due that. -- 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 _______________________________________________ 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
