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're a bit over my head, but . . .
wouldn't that left join bring *all* the entries for table2 and their
numbers in, so that I would still get repeated animals?
Should there be a . in the middle of the last word?
In test,
Select debtor_table uniqDna, debtor_table cname from (select
distinct cname FROM debtor_table as mytable2) left join debtor_table
ON debtor_table.cname = mytable2.cname ;
and I get,
revdberr,Database Error: no such column: mytable2.cname
(in fact, I need cname||cadr, not just name, as some creditors end up
with multiple addresses)
--
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
