On Thu, Mar 28, 2019 at 4:07 PM David G. Johnston < david.g.johns...@gmail.com> wrote:
> On Thu, Mar 28, 2019 at 4:05 PM Ken Tanzer <ken.tan...@gmail.com> wrote: > >> >> (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; >> >> > The fact that the subquery has a LIMT 1 clause leads me to assume the > ORDER BY there is quite necessary. > > David J. > Have to agree with you there. Sorry for the brain fart! 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.
