JOIN THIS_ID IN FILE1 TO UNIQUE THAT_ID IN FILE2 TAG J001 AS J001

In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.    Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206

SET TRACEOFF = ALL
SET TRACEON = STMTRACE//CLIENT
SET TRACEON = SQLAGGR//CLIENT
SET TRACEUSER = CLIENT

SET SQLTOPTTF = ON
SET TRACEOFF  = ALL
SET TRACESTAMP= OFF
SET TRACEWRAP = 72
SET TRACEON   = SQLTRANS
SET TRACEON   = SQLAGGR//CLIENT
SET TRACEON   = STMTRACE//CLIENT
SET TRACEON   = STMTRACE/1/CLIENT
SET TRACEON   = STMTRACE/2/CLIENT
SET TRACEUSER = ON
SET MSG       = ON
SET HOLDSTAT  = ON
SET EMGSRV    = ON
-SET &ECHO    = ALL;

SET TRACEOFF=ALL
SET TRACEUSER=CLIENT
SET TRACEON=SQLAGGR//CLIENT
SET TRACEON=STMTRACE//CLIENT
SET TRACEON = STMTRACE/2/CLIENT
SET TRACEON = SQLTRANS
SET TRACESTAMP = OFF
-RUN
JOIN LEFT_OUTER THIS_ID IN FILE1 TO UNIQUE THAT_ID IN FILE2 TAG J001 AS J001
-RUN
TABLE FILE DF_FILE1
BY THIS_ID
ON TABLE HOLD
END
-EXIT
NUMBER OF RECORDS IN TABLE=        1  LINES=      1
There are        1 lines;
AGGREGATION DONE ...
SELECT
T1."THIS_ID",
MAX(T1."PRESCRIBER_ID")
FROM
FILE1 T1
WHERE
(T1."THIS_ID" >= 0)
GROUP BY
T1."THIS_ID"
ORDER BY
T1."THIS_ID"
FOR FETCH ONLY;

SELECT
T1."THISID",
T2."SOME_DATE",
MAX(T1."THISID")
FROM
( FILE1 T1
LEFT OUTER JOIN FILE2 T2
ON T2."THAT_ID" = T1."THISID" )
WHERE
(T1."THISID" >= 0)
GROUP BY
T1."THISID",
T2."SOMDATE"
ORDER BY
T1."THISID",
T2."SOMDATE"
FOR FETCH ONLY;