phoenix_me
Member
I have a table which look like below
Is it possible to build ONE query which will include all rows from last 60 days (based on dDate field) and all rows where iKey1 = iKey1 from results from last 60 days?
Code:
DEFINE TEMP-TABLE Changes
FIELD iKey1 AS INTEGER
FIELD dDate AS DATE
FIELD cChanges AS CHARACTER FORMAT "X(1000)"
.