Re: Subquery to select max(date) value

[Ken Tanzer <ken.tanzer@xxxxxxxxx>]

On Thu, Mar 28, 2019 at 4:07 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Thu, Mar 28, 2019 at 4:05 PM Ken Tanzer <ken.tanzer@xxxxxxxxx> 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/

https://demo.agency-software.org/client

ken.tanzer@xxxxxxxxxxxxxxxxxxx

(253) 245-3801

Subscribe to the mailing list to

learn more about AGENCY or

follow the discussion.