Re: Subquery to select max(date) value

On Thu, Mar 28, 2019 at 4:14 PM Rich Shepard <rshepard(at)appl-ecosys(dot)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(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.