I have a table that looks like that:
I need to add 2 columns to the table with the min and max IVR_DATE of the PPR.
How can i do it in the script when i'm loading the table?
Thx for help and sry for bad english
(html, codepage is 1252, embedded labels, table is @1);
Left Join (Table)
Date(Min(IVR_DATE)) as MinDate,
Date(Max(IVR_DATE)) as MaxDate
Group By PPR;
Use the same table and use Resident option calculate the Min & Max dates. Finally Join back to your main table.
Retrieving data ...