Re: Subquery to select max(date) value [RESOLVED]

2019-03-29 Thread Rich Shepard
On Fri, 29 Mar 2019, Andrew Gierth wrote: That query seems correct assuming you want the result in descending order of next_contact. How did the actual result differ from your expectation? Andrew, User error: I had a couple of date typos (2018 rather than 2019) and was thinking of generating

Re: Subquery to select max(date) value [RESOLVED]

2019-02-12 Thread Rich Shepard
On Tue, 12 Feb 2019, David G. Johnston wrote: You put the open parenthesis after the word select instead of before. A.next_contact = (SELECT max(A.next_contact) FROM A) David. Color me suitably embarrassed. Thank you, Rich