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. Thanks, Rich
