On Thu, Mar 28, 2019 at 4:14 PM Rich Shepard <rshep...@appl-ecosys.com> wrote:
> On Thu, 28 Mar 2019, Ken Tanzer wrote: > > > You need the ORDER BY in the outer join. > > Ken, > > I thought so. But, ... > > > (And I don't think the one inside the lateral join is doing you any > good). > > Try: > > ... > > a.next_contact is not null > > limit 1) sq > > order by sq.next_contact DESC; > > This re-orders the returned set, but still not in chronological order. > Really? Is your next_contact field a date field and not a text field? What order does it come out in? (And I assume you saw David J's correction to the misinformation I offered.) Cheers, Ken -- AGENCY Software A Free Software data system By and for non-profits *http://agency-software.org/ <http://agency-software.org/>* *https://demo.agency-software.org/client <https://demo.agency-software.org/client>* ken.tan...@agency-software.org (253) 245-3801 Subscribe to the mailing list <agency-general-requ...@lists.sourceforge.net?body=subscribe> to learn more about AGENCY or follow the discussion.
