Re: Selecting table row with latest date

[Rob Sargent]

> On Aug 19, 2021, at 10:59 AM, Rich Shepard <rshep...@appl-ecosys.com> wrote:
> 
> On Thu, 19 Aug 2021, Rob Sargent wrote:
> 
>> Yeah, but my quibble is the the table you described up-thread. Your
>> contact table contains next_contact? I think that column should be
>> normalized out.
> 
> Rob,
> 
> Why should I have a separate table with one column: next_contact? The
> next_contact date is associated with a person and the date that person was
> contacted.
> 
> Rich

sorry, wasn’t clear: person_nbr, next_contact
On the premise that there can only be one next date.

> 
> 
> 
>